Due to either space constraints or performance issues the CMDB needs to be moved to a new SQL Server.
Disclaimer: The following steps are provided as reference. Questions or concerns or for more details about how to migrate a database from a SQL Server, please contact Microsoft. ALSO, see document references below under 'Related Articles.'
Login to all servers, SMP, Current SQL and New SQL servers using the Account used to install the SMP! This will maintain correct ownership of the database when exported and maintain alignment on the import.
The following solution involves several steps:
NOTE: Symantec Management Platform 8.1 does not allow a database change in console, please use the Symantec Installation Manager.
See details below.
Pre-move check on the destination SQL Server.
1. Verify that the SQL Server version, service pack and edition are supported by the Symantec Management Platform.
2. Verify that the Symantec_CMDB database collation matches the destination SQL Server collation.
Symantec_CMDB database collation will be in the database properties. SQL Server collation will be in the SQL Server instance properties.
Following SQL Query can also show the master database (SQL Server instance) and user database collation.
select sdb.name ,sdb.collation_name from sys.databases as sdb
The master database collation must match the Symantec_CMDB database collation to avoid a collation conflict.
3. Backup the Symantec Management Platform server following the steps from the IT Management Suite Disaster Recovery White Paper.
Backup the Configuration Management Database
Restoringthe Configuration Management Database
Setting the appropriate permissions to the SQL database
Symantec Management Platform 8.1 and newer
1. Logon to the Management Platform Server with the application service account (Altiris Service).
2. Start the Symantec Installation Manager.
3. Configure settings> Configure Database Settings, Next.
4. Change the SQL Server/Instance name to the new server with the moved Symantec_CMDB database.
5. Select the correct Symantec_CMDB database and press Next.
Symantec Management Platform 8.0 and older
Change the database location referenced by the Management Platform:
Two methods to point the Symantec Management Platform to the new SQL Server and CMDB
After performing the operations required to relocate a copy of the existing database, choose one of the below methods to redirect the location used by the Management Console for storage.
A. Backup and Restore of existing database, then transfer of connectivity to new DB Server
(DB running on both servers)
B. Backup and Restore of existing database, modify CoreSettings.Config and Registry to change to new DB Server
(DB running on new server only)
If the database is simply being moved from one database server to another, and the Notification Server has not changed etc then simply do the following steps: