Systems Management Server Database Download

							Systems Management
Server 2003 Backup and
Recovery

Wally Mead
Program Manager
Systems Management Server
Microsoft Corporation
Session Agenda
   The backup and recovery process in Systems
    Management Server (SMS) 2003
   SMS site recovery rules
   Understanding SMS site recovery
   Summary of supported recovery scenarios
   Supported recovery configurations
   Understanding SMS serial numbers
   Testing a backup and recovery plan
   SMS site recovery tools
                                                 2
Overview of Backup and
Recovery
   Automated built-in task
       Backup SMS site server backs up:
         Microsoft® SQL Server™ database
         Site server directories
         Registry configuration
         Microsoft Windows® operating system
           configuration information
       Included in both SMS 2.0 and SMS 2003
   Recovery is easier in SMS 2003
       SMS 2.0 required PSS intervention for tools
       Maintenance and recovery Web site
                                                      3
SMS Site Recovery Rules
   Site recovery:
       Begins when an SMS site code or site server
        name is reused in a hierarchy
       Is specific to that site hierarchy
   Site recovery is important because:
       Repairing and resynchronizing data are key
        tasks in a site recovery operation
       It is required to prevent interruption of
        operations and corruption of data in the
        hierarchy



                                                      4
Understanding SMS Site
Recovery
   SMS aspects that impact recovery
       SMS uses distributed data and tasks
       SMS uses multiple accounts
       SMS 2.0 secondary sites are not backed up
   Key recovery strategies
       Restore requires a snapshot backup
       Recovery without a backup is possible with data
        loss
       Serial numbers must be resynchronizeded in
        recoveries involving site hierarchies


                                                          5
Summary of Supported Recovery
Scenarios
   The physical computer stops responding
   The drive containing Microsoft
    Windows NT® or Windows 2000, SQL
    Server, or Systems Management Server
    (SMS) stops responding
   Windows NT or Windows 2000 stops
    responding and must be restored
   The file system becomes corrupted
   SQL Server stops responding and must be
    restored
   The SQL Server database becomes
    corrupted                                 6
Supported Recovery
Configurations
   SQL Server 6.5 (SMS 2.0 only), SQL Server
    7.0, and SQL Server 2000
       Local or remote
   Local or remote SMS provider
   With no backup, old backup, or current
    backup
   Secondary site or primary site with or without
    a parent site
   Recovering a primary site with:
       No child sites
       Any mix of secondary and primary child sites   7
Understanding SMS Serial
Numbers
   Serial numbers are used for the next object
    created
   Must be synchronized upon a recovery,
    otherwise data loss or corruption may occur
   SMS site database
       Select * from NextIds
   SMS registry keys
       Replication Manager
       Discovery Data Manager
       Site Control Manager
   SMS installation directory
       Sms\Inboxes\Replmgr.box\History\sitecode.trs   8
Testing a Backup and Recovery
Plan

   Planning – cover all potential issues
   Backup – verify backup plan is working as
    expected
   Test recovery – verify it is possible to
    recover if required




                                                9
Planning Phase
   Document:
       Site hierarchy structure and site codes
       All custom accounts created
       Domain structure and trusts
       Any customizations to SMS
       SMS serial numbers (NextIds table and
        Replication Manager history file)
   It is necessary for the administrator to
    create an SMS client connection account
       If not, clients can be orphaned
       Required for SMS 2.0 and SMS 2003 if
        standard clients are used
                                                  10
Backup Phase
   Use Backup SMS Site Server task
       Automated procedure to safely back up a site server
       Copies important site server files (not binaries)
       Copies SMS-related registry data
       Copies SQL Server database
       Creates log of server configuration data
       Can run optional procedures after backup
   SMS 2003 supports backup of secondary sites
   Copy the backup to tape and store the tape offsite
       Do not leave data on the site server
   Option to manually back up distribution points
       SMS can redeploy packages
   No real need to back up other site systems
       Easy to re-create after a restore process             11
Test Recovery Phase
   Verify that the backup plan works
        Ensure necessary data was backed up
        Ensure plan can be used to recover site in a
         timely manner
   Three steps
    1.   Rebuild – SQL and SMS servers
    2.   Restore – data to rebuilt servers
    3.   Repair – resynchronize site and hierarchy data
   Restoring recovery data is the last step in
    a standalone site scenario
   Repair is necessary for site hierarchies
                                                          12
Tools to Help with Backup and
Recovery
   SMS Maintenance and Recovery Web site
       Contains all documents necessary for planning
       Contains documents for server hardware swapping
       Contains SMS Site Recovery Expert
   SMS Site Recovery Expert
       Interactively queries administrator for site information
       Displays required steps for recovery
       Included with SMS 2003 and runs locally
   SMS Site Repair Wizard
       Helps with repairing a failed site that is a member of a
        site hierarchy
       Can perform restore phase automatically
       Included with SMS 2003
                                                                   13
SMS Maintenance and Recovery Web
Site
   Contains documents on:
       Planning for recovery
       Supported scenarios and configurations
       Swapping server hardware
       Moving SMS between domains
       Frequently asked questions (FAQ)
   Contains SMS Site Recovery Expert
       No sensitive data is required or sent to Microsoft
       For SMS 2.0 only
   Available at:
    http://www.microsoft.com/smserver/techinfo/
    administration/20/recovery/default.asp                   14
SMS 2003 Site Recovery Expert
   Included with SMS 2003
       Supports both SMS 2003 and SMS 2.0 sites
       Must be installed manually
         Requires Windows 2000 SP2 or later and
           Internet Information Server 5.0 or later
       Runs locally, not from Internet
       Running the Recovery Expert requires
        Internet Explorer 5.5 or later
       Includes tasks for hardware swapping scenarios
   Creates local Web site
    http://server/SMSRecoveryExpert/
   Can produce a list of all possible recovery
    tasks
       Useful for documentation and preparation for
        processes                                        15
SMS 2003 Site Recovery Expert
Installation Screen Shot




                                16
SMS 2003 Site Recovery Expert
Required Information

   Version of SMS is being recovered (SMS 2003 or
    SMS 2.0)
   SMS site system that failed and requires recovery
   Primary or secondary site failure
   Hierarchy information
   Availability of a backup and changes since backup
   Intended use of the Repair Wizard




                                                        17
SMS 2003 Site Recovery Expert
SMS Site Recovery Expert Screen Shot




                                       18
SMS 2003 Site Recovery Expert
Site Recovery Task List

   Steps to be manually performed:
    1.   Preparation steps
          Gather the software, documentation, and tools
    2.   Rebuild steps
          Reinstall operating system, install new
            SQL Server, reinstall SMS
    3.   Restore steps
          Restore directories, database, registry, and
            permissions
    4.   Repair steps
          Synchronize with the rest of the hierarchy,
            increment IDs, install QFEs, and recreate
            manual accounts
    5.   Print the task list for reference
                                                           19
SMS 2003 Site Recovery Expert
Recovery Task List Screen Shot




                                 20
SMS 2003 Site Repair Wizard

   Included with SMS 2003
       Supports both SMS 2003 and SMS 2.0 sites
   Installed automatically
   Runs from SMS program group or SMS
    Administrator Console
   Can perform automatic restoration of SMS
    backup
   Performs automatic repair of site hierarchy
   Retrieves object data from child sites
   Retrieves site configuration data from
    parent site                                    21
SMS 2003 Site Repair Wizard
Launch Screen Shot




                              22
SMS 2003 Site Repair Wizard
Wizard Phase

    Prompts for server to be repaired
    Informs user of:
        Required rights
        Mandatory steps to be completed
    Queries for:
        Manual or automated restore
        Last backup date and date of failure
        Site hierarchy information
    Checks parent for connectivity
    Checks reference sites
    Requests object ID padding values          23
SMS 2003 Site Repair Wizard
Restore and Failure Dates




                              24
SMS 2003 Site Repair Wizard
Site Hierarchy and Reference Sites




                                     25
SMS 2003 Site Repair Wizard
Repair Phase

   Removes CAP data files
   Retrieves site control file from parent
   Rebuilds child site addresses
   Deletes orphaned parent data
   Updates transaction IDs and serial numbers
   Regenerates lost software object definitions
       Prevents orphaned data on child sites



                                                   26
SMS 2003 Site Repair Wizard
Recovered Data




                              27
SMS 2003 Site Repair Wizard
Completion

    Verifies each package source
    Can force package refresh to local
     distribution point
    Restarts SMS services
    Lists tasks to be manually verified
        Verify child sites are reporting properly
        Look for missing orphaned data
        Verify package deployments
        Configure any site settings

                                                     28
SMS 2003 Site Repair Wizard
Completion Screen Shot




                              29
Summary
   Backup and recovery are easier in SMS 2003
    than in SMS 2.0
       Secondary sites are supported for backup and recovery
   Recovery is required if you reuse a site code
    or server
   SMS serial numbers must be resynchronized
    during a recovery of a site in a hierarchy
       If not completed correctly, data corruption can occur
   Testing your backup and recovery plan is
    necessary
   The SMS Site Recovery Expert provides
    details and procedures for site recovery
   The SMS Site Repair Wizard automates
    restore and repair processes                                30
Thank you for joining today’s Microsoft Support
WebCast.

For information about all upcoming Support WebCasts,
and access to the archived content (streaming media
files, PowerPoint® slides, and transcripts), visit:
http://support.microsoft.com/webcasts/

Your feedback is sincerely appreciated. Please send any
comments or suggestions about the Support
WebCasts to supweb@microsoft.com.
                                                          31