Backup and Recovery Frequently Asked Questions


Q. How do I recover SMS data that was not backed up? (Updated July 30, 2004)

A. Use the SMS Site Repair Wizard to recover data from parent and child primary reference sites. For more information about the SMS Site Repair Wizard, see “Appendix F: Recovery and Repair Tools” in Scenarios and Procedures for Microsoft Systems Management Server 2003: Backup, Recovery and Maintenance on the Microsoft Download site.

Q. Can I restore an SMS site from backup to a different computer? (Updated July 30, 2004)

A.

You can restore an SMS site to a different computer. However, the computer must have the same name and be in the same domain as the site that failed.

For more information about supported configurations and recovery scenarios, see Recovering a site in Scenarios and Procedures for Microsoft Systems Management Server 2003: Backup, Recovery and Maintenance on the Microsoft Download site.

Q. Can I change the SQL Server configuration when I restore an SMS site? (Updated July 30, 2004)

A.

No. The SQL Server configuration on the restored site must be identical to that of the failed site.

For more information about supported configurations and recovery scenarios, see Recovering a site in Scenarios and Procedures for Microsoft Systems Management Server 2003: Backup, Recovery and Maintenanceon the Microsoft Download site

Q. How do I specify the backup location when I use the SMS Site Repair Wizard? (Updated July 30, 2004)

A.

Specify the path to the backup location, but do not specify the <Site Code>Backup folder. For example, if the backup is in C:\Data\ABCBackup, then specify C:\Data as the backup location.

For more information about the SMS Site Repair Wizard, see “Appendix F: Recovery and Repair Tools” in Scenarios and Procedures for Microsoft Systems Management Server 2003: Backup, Recovery and Maintenanceon the Microsoft Download site.

Q. I selected Update the distribution point on the site server on the Package Recovery page in the SMS Site Repair Wizard. Why weren’t my packages restored?

A.

The SMS Site Repair Wizard can use reference sites to recover package definitions which were created after the last site backup. However, the SMS Site Repair Wizard does not recover the distribution points associated with those packages. If you select Update the distribution point on the site server on the Package Recovery page in the wizard, the wizard can only update distribution points for packages which are recovered from the backup snapshot. After the SMS Site Repair Wizard completes the site repair phase, you must manually update, and then add, distribution points for each package that was recovered from a reference site. Although initially the package has no distribution points, you must update the package before adding distribution points to the package.

For more information, search on “SMS Site Repair Wizard” and “Recover Package Definitions from Child Reference Sites” in the SMS 2003 Operations Release Notes.

Q. How do I perform site recovery of sites configured with SQL Server database replication?

A.

The Recovery Expert does not provide detailed steps for reconfiguring Microsoft SQL Server™ database replication for SMS after a site recovery. If you used SQL Server database replication with an SMS management point or with a server locator point, you must delete any existing SMS database replication objects before restoring the site database, and then recreate them after restoring the site database. Before restoring the site database, perform the following steps:

  1. Delete all subscriptions to the SMS publication.
  2. Delete the subscription database.
  3. If the SMS publication still exists, delete the publication.

After restoring the site database from the backup snapshot, perform the following steps:

  1. Disable the site database server as a publisher.
  2. Re-enable the site database server as a publisher.
  3. Recreate the publication, subscription, and subscription database. You must recreate the publication by using the MPPublish.vbs script. The MPPublish.vbs script is on the SMS 2003 product CD, in the \SMSSetup\bin\i386 folder.

For more information about configuring SQL Server database replication, see Chapter 8, “Designing Your SMS Sites and Hierarchy,” in the Microsoft Systems Management Server 2003 Concepts, Planning, and Deployment Guide, and the SQL Server documentation.


For More Information

Did you find this information useful? Send your suggestions and comments about the FAQ to smsdocs@microsoft.com.

Top of page Top of page