How to move a Deployment Server SQL database from one SQL server to another
Last Updated December 05, 2016
Question What steps are required to move a DS SQL database from one SQL server to another SQL server?
Answer The steps for moving a Deployment Solution database from one SQL server to another are:
Backup the database.
Restore the database to the cluster.
Make sure that the DS service account has at least DBO rights to the database on the new SQL server
Stop the Deployment Server Services ("Altiris eXpress Server", "Altiris Deployment Server Data Manager", and "Altiris Deployment Server DB Management")
Redirect the ODBC to the database on the SQL cluster.
Open C:\Windows\SysWOW64 and run odbcad32.exe
Switch to the System DSN tab.
Select your Altiris Express database.
Change the SQL Server you want to connect to in the drop down box at the bottom of that window.
Restart the services stopped in step 4
Note: If there are any problems encountered then you can run DSSetup and do a custom install and allow this installation process to run. It should detect the database on the new SQL server referenced by the ODBC connection and the process should complete successfully, allowing Deployment Solution to communicate with the database in the new location.
Imported Document ID: HOWTO9369
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe