Before you upgrade Analysis Center, you must back up the AC_Warehouse and AC_Configuration databases on Data Warehouse and all the Data Mart computers. You must use a domain or local administrator account that belongs to the System Administrators group for the SQL Server.
To back up Analysis Center databases:
Launch the Analysis Center Console and perform the following tasks:
Ensure that there are no items in the Pending Data Sources list. Right-click each Data Source in the Pending Data Source list and either activate or remove the Data Source.
Disable all the Data Sources. You must disable a Data Source only after the ETL and OLAP Processing jobs for the Data Source have successfully run.
Close the Analysis Center Console.
Start SQL Server Management Studio and do the following:
Connect to the Data Warehouse SQL Server and disable the OLAP Processing job.
Connect to the Data Mart SQL Server and disable the ETL Processing jobs for the Data Source.
Perform the following tasks on the AC_Warehouse, AC_Configuration, and each Data Mart database:
Right-click the database you want to back up and click Tasks > Backup Database.
On the General tab, click Add.
In the Select Backup Destination dialog box, specify the file name and follow the on-screen prompts.