INFO: Moving SQL Database From Site Server to Another SQL Server Machine

ID: Q200347

The information in this article applies to:

SUMMARY

Systems Management Server (SMS) setup program can be used to reconfigure a SMS Site to use a new SQL Server location and database.

The following steps outline the procedures for moving SQL server from the SMS site server to a new machine. Please refer to SQL documentation for installation, backup, and restore procedures.

  1. Stop all SMS services.


  2. Backup SQL database in its original location.


  3. Install SQL server on the new machine using the same configurations (i.e. Sort Order, Character set, etc.).


  4. Restore the database on the new SQL server machine.


  5. Run SMSSetup. Under setup options, select "modify or reset current installation," and then provide SMS service account information on the next screen. Then, under the "database modification screen," change the SQL server name and/or Database name to the new SQL server name/database name.


NOTE:
  1. SMS_SITE_COMPONENT_MANAGER service on the site server will automatically uninstall the SMS_SQL_MONITOR service from the site server and install it on the new SQL server machine. This occurs at the end of the "Site Modify" operation in SMS Setup.


  2. The SMS_Provider remains in the same location, in this case on the site server, because it cannot be moved once it is installed. This will result in network activity between the SMS Provider and the SQL database.

Additional query words: prodsms dbmaint sms20 smssql 


Keywords          : kbSMS200 
Version           : winnt:2.0
Platform          : winnt 
Issue type        : kbinfo

Last Reviewed: March 17, 1999