Before you migrate data, back up the following databases of your current version of Analysis Center using a domain or local administrator account that belongs to the System Administrators group for the SQL Server:
AC_Warehouse and AC_Configuration databases on the Data Warehouse
All Data Mart databases
AC_OLAP database
To back up the Analysis Center databases:
Start SQL Server Management Studio.
Connect to the Data Warehouse SQL Server and disable the OLAP Processing job.
Ensure that the ETL Jobs are disabled.
Perform the following tasks on the AC_Warehouse, AC_Configuration, and each Data Mart database:
In the Object Explorer, expand Databases.
Right-click the database you want to back up and select Tasks > Back up.
In the Back Up Database - Database Name window, select General page. In the Destination group box, click Add. In the Select Backup Destination dialog box, specify the file name and click OK.
Perform the following tasks on the AC_OLAP database:
Log in to an SQL Server Analysis Services (SSAS) instance from the SQL Server Management Studio.
Right-click the SSAS database you want to back up.
Select Back Up.
The selected database name appears in the Database option. Specify the name of the Backup file. If you do not specify the path, the backup files are saved in a default folder. For example, C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Backup.