Microsoft TechEd India 2012 Backup Restore

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.
  Native T-SQL commands
• 6.
  Native Backup andRestore Backup/ Restore Database • Full Piecemeal • T-Log Options • Differential • File/Filegroup Backup Options
• 7.
  VSS Volume Shadow Service
• 8.
  VSS – VolumeShadow Service
• 9.
  DEMO
• 10.
  VDI Virtual Device Interface
• 11.
  VDI – VirtualDevice Interface SQLVDI Types of Backup APIs Full Device Config Log Differential File/Filegroup
• 12.
  DEMO
• 13.
  Planning
• 14.
  Planning Document/ RPO/RT Dry Run O VLDB Automate options
• 15.
  Demystify
• 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.
  DEMO
• 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