Uploaded byAmit Banerjee
Microsoft TechEd India 2012 Backup Restore
The document discusses various methods of SQL Server backup and restoration, including native, VSS, and VDI options. It emphasizes the importance of planning for backups and addresses some common misconceptions about backup processes. The presentation also includes resources and contact information for further assistance.
Microsoft TechEd India 2012 Backup Restore
- 1. Lesser Known facts of SQL Server Backup GO BIG! Amit Banerjee and Restore www.troubleshootingsql.com http://twitter.com/banerjeeamit
- 2. About Me SQL Server Escalation Services Community Speaker Premier Field @ SQL Saturday | SQL Engineer based Virtual Tech Days | Nexus, Backup out of Bangalore Tech Ed Simulator, SQLD IAG 6 years as Configuration MSFT Manager
- 3. Agenda Backup/ Restore Planning Demystify #TechEdIn | @banerjeeamit
- 4. Types Backup/Restore can bedone in three different ways Native VSS VDI T-SQL Volume Shadow Virtual Device commands Service Interface T-SQL Snapshot 3rd Party Tools
- 5.
- 6. Native Backup andRestore Backup/ Restore Database • Full Piecemeal • T-Log Options • Differential • File/Filegroup Backup Options
- 7.
- 8. VSS – VolumeShadow Service
- 9.
- 10.
- 11. VDI – VirtualDevice Interface SQLVDI Types of Backup APIs Full Device Config Log Differential File/Filegroup
- 12.
- 13.
- 14. Planning Document/ RPO/RT Dry Run O VLDB Automate options
- 15.
- 16. Demystifying Some unknowns thatare worth knowing!!! BUFFERCOU MAXTRANSFERSIZ NT E I/O is frozen on database msdb. No user action is required. I/O was resumed on database Full backup msdb. No user action is doesn’t break required. backup chain!
- 17.
- 18. Thank you fortime and patience! Hope you had as much fun as I did in presenting the same! Contact Details facebook.com/TroubleshootingSQL http://twitter.com/banerjeeamit http://twitter.com/TblShootingSQL www.troubleshootingsql.com
- 19. © 2012 MicrosoftCorporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the US and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
- 20. Resources Developers Infrastructure Professionals http://msdn.microsoft.co http://technet.micorsoft.com/ m/ @msdnindi technetindia @technetindia msdnindia a
Editor's Notes
- #15 RPO/RTODefine SLAIdentify DR optionsAutomateHave scripts/batch files readyMake sure backups are accessibleVLDBsExplore piecemealUse features like striping/compressionTeamDry RunsDocument