4.2 Backing Up Databases Before Upgrading

Before you upgrade, back up the following Analysis Center databases of your current version of Analysis Center: AC_Warehouse and AC_Configuration databases on the Data Warehouse, and all Data Mart databases. You must belong to the System Administrators group for the SQL Server, using a domain or local administrator account.

To back up Analysis Center databases:

  1. Open the Analysis Center Console and do the following tasks:

    1. Ensure that there are no pending Data Sources by right-clicking each pending Data Source and selecting either Create or Remove.

    2. After the ETL and OLAP Processing jobs running for each Data Source are complete, disable the Data Sources.

    3. Close all Analysis Center Consoles.

  2. Start SQL Server Enterprise Manager.

  3. Connect to the Data Warehouse SQL Server and disable the OLAP Processing job.

  4. Connect to the Data Mart SQL Server and disable the ETL Processing jobs for the Data Source.

  5. Do the following tasks on the AC_Warehouse, AC_Configuration, and each Data Mart database:

    1. Expand the computer with the database.

    2. Right-click and select All Tasks > Backup Database.

    3. On the General tab, click Add and then specify the File name by clicking [...] in the Select Backup Destination dialog box. Click OK.