In planning your database maintenance strategy, evaluate how you address event activity. You can then use this information to help you establish a schedule for regularly backing up the Control Center repository.
Also back up the CCDB if you move the database server to another computer, or if you upgrade from a 32-bit SQL Server installation to a 64-bit SQL Server installation. If you are moving the 32-bit CCDB to a 64-bit SQL Server computer, make sure you have the latest 32-bit hotfixes and modules. After you move the QDB to the 64-bit SQL Server computer, you cannot install the 32-bit hotfixes and modules.
NOTE:
The master database holds all of the device configuration information, SQL Server login information, and extended stored procedures. Therefore, periodically back up the master database even if you are not backing up the CCDB—especially if you add data devices, databases, or users, or change any configuration options.
If you want to move a 32-bit CCDB to a 64-bit SQL Server, update your current AppManager installation to AppManager version 7.0.3 and migrate your data. For more information about updating to AppManager version 7.0.3, contact NetIQ Technical Support.
You can achieve the following results if you take regular, scheduled backups of the Control Center repository:
Ensure the integrity of the data stored in the Control Center repository.
Provide a means for archiving historical information.
Prevent data loss.
Facilitate disaster recovery.
Although you can back up the repository manually at any time using SQL Server Management Studio or with the SQL_RunSQL Knowledge Script, both Management Studio and the RunSQL script allow you to automate backups by scheduling them to run at set intervals or at specific days and times.
The frequency of your backups depends on the nature of your environment, including the size of the data and log files, the number of computers you monitor, the number of Knowledge Scripts you run, and how quickly you acknowledge and close events.
As a general rule, perform a complete or incremental backup at least once a week.
For more information about preparing the CCDB for backup, backing up the CCDB, and restoring the CCDB, see the Upgrade and Migration Guide for AppManager, available on the AppManager Documentation page. When preparing to back up the CCDB, if you are only backing up the CCDB and not moving it to another computer, only perform the steps related to the following:
Noting properties for SQL Server logins
Closing open connections
Verifying that there are no open connections