How do I restore the SMS database?

Product / Version includes:

Applies to all products

Last updated: 2024/08/02

Solution ID: KA-0017349

Category: Configure , Troubleshoot , Deploy

Summary

The SMS server maintains important data in both its database and configuration files. The database holds data about the current and historical operations of the SMS server and the devices it manages. The configuration files contain SMTP server information, NAT configuration information, and user information. This data is critical to the operation of the SMS Server and should be backed up periodically to facilitate recovery from an unexpected failure.

Restore

When restoring an SMS Server database, SMS validates the integrity of the file from which backed-up data is being restored. If the file is invalid, the SMS console displays an error message. To ensure database integrity, the system automatically reboots after the restore operation. For example, you can restore a backup taken with SMS v5.3 and restore it to an SMS v5.5 server. When you restore a previous-version backup, SMS not only restores the database but properly migrates the data and data structures to match the version of SMS currently running on your SMS server.

NOTE: If you restore a backup to an SMS server upon which SMS patches are installed, you may need to roll back and reapply the patch after you restore the backup. The restoration process will indicate in a dialog box if you need to perform this task.

NOTE: Before you initiate the restore process, ensure there are no active client connections to the SMS server through the SMS client, command line interface, or Web browser.

Procedure:

Log in to the SMS client and navigate to Admin > Database > Backup
On the Backup and Restore screen, click Restore.
In the SMS Restore wizard, select the backup file you want to restore and click OK.
Click Import.
- The SMS Restore wizard verifies the integrity of the chosen file and proceeds if it is valid. If it is invalid, the SMS displays an error message.
A summary page appears. If the information is correct, click Finish.
- Database restoration begins, with the restored data overwriting the existing data. Once complete, the SMS Server reboots to finalize the restore process and ensure the restored database's data integrity.

Reference: SMS User Guide

Was this article helpful?

Featured

Automation Center

Education Portal

Online Help Center

Service Status

TrendConnect

How do I restore the SMS database?

Procedure:

How do I restore the SMS database?

Product / Version includes:

Summary

Procedure: