Systems Management Server 2003 Backup and Recovery Wally Mead Program Manager Systems Management Server Microsoft Corpo - PowerPoint PPT Presentation

Albert_Lan
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Systems Management Server 2003 Backup and Recovery Wally Mead Program Manager Systems Management Server Microsoft Corpo PowerPoint Presentation
Download Presentation
Systems Management Server 2003 Backup and Recovery Wally Mead Program Manager Systems Management Server Microsoft Corpo

play fullscreen
1 / 31
Download Presentation
Systems Management Server 2003 Backup and Recovery Wally Mead Program Manager Systems Management Server Microsoft Corpo
486 Views
Download Presentation

Systems Management Server 2003 Backup and Recovery Wally Mead Program Manager Systems Management Server Microsoft Corpo

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

    1. Systems Management Server 2003 Backup and Recovery Wally Mead Program Manager Systems Management Server Microsoft Corporation

    2. 2 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

    3. 3 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

    4. 4 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

    5. 5 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

    6. 6 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

    7. 7 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

    8. 8 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

    9. 9 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

    10. 10 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

    11. 11 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

    12. 12 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 Rebuild SQL and SMS servers Restore data to rebuilt servers Repair resynchronize site and hierarchy data Restoring recovery data is the last step in a standalone site scenario Repair is necessary for site hierarchies

    13. 13 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

    14. 14 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

    15. 15 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

    16. 16

    17. 17 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

    18. 18

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

    20. 20

    21. 21 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

    22. 22

    23. 23 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

    24. 24

    25. 25

    26. 26 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

    27. 27

    28. 28 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

    29. 29

    30. 30 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

    31. 31 Thank you for joining todays 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.