Moving the SMS Site Database

  • Article

To accommodate growth and other changes in your organization, you might want to move the SMS site database to a remote database server. Moving the SMS site database to a remote server is performed in the same manner for the following two scenarios:

  • Moving a local SMS site database to a remote server

  • Moving the SMS site database from one remote server to another remote server

When moving the SMS site database server, SMS moves the SMS Provider to the same server that the SMS site database is moving to

To move SQL Server to a remote server

  1. Install SQL Server on the remote server.

  2. Configure the new SQL Server database security so it is similar to the old SQL Server security configuration. Configure accounts and permissions required for SMS to manage SQL Server.

  3. Stop the following SMS services:

    On the site server:

    • SMS_SITE_COMPONENT_MANAGER

    • SMS_EXECUTIVE

    On the old database server:

    • SMS_SQL_MONITOR_<SiteServerName>

  4. Back up the SMS site database from the old SQL Server database by using the SQL Server Backup Database tool.

  5. Restore the SMS site database to the new SQL Server database by using the SQL Server Restore Database tool.

  6. On the site server, run the SMS Setup Wizard:

    • On the Setup Options page, select Modify or reset the current installation.

    • On the Database Modification page, specify the new database server name and the appropriate database name.

    • Complete the SMS Setup Wizard.

  7. You can now delete the SMS site database from the old SQL Server database, or disconnect the old database server (if it is on a remote computer).

Note

  • While using the new SMS site database server, SMS generates error status messages as it continues to attempt to access the old SQL Server. You can safely ignore those status messages.
For More Information

Did you find this information useful? Please send your suggestions and comments about the documentation to smsdocs@microsoft.com.