[Previous] [Next]

Chapter Summary

SMS databases use many SQL Server features, such as indexes and triggers, for performance and system maintenance. The SMS database is maintained using SQL Server tools and objects below the SMS Administrator console's Database Maintenance node. Database maintenance includes site server and site database backup routines.

SMS databases can be moved and entire sites can be restored. The success of a site restore depends on complete and regular backups being done on the site server and the site database server. Non-site server site system recovery is handled through the SMS Administrator console and takes minimal intervention on the part of an administrator.