Before you migrate data, back up the Data Warehouse, Data Mart, and OLAP databases of your current version of Analysis Center.
To take back up, you must belong to the System Administrators group for the SQL Server, with a domain or local administrator account.
You need to back up the following Analysis Center databases:
AC_Warehouse database on the Data Warehouse
AC_Configuration database 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.
Verify whether ETL Jobs is disabled and disable it if it is not already 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 and then specify the File name by clicking [...] in the Select Backup Destination dialog box. Click OK.
Perform the following tasks on the AC_OLAP database:
Log in to an SSAS (SQL Server Analysis Services) instance from SSMS (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 field. Specify the name of the Backup file. If you do not specify the path, the backup files will be saved in a default folder (for example, C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Backup).