Backup to the Cloud
Backup to the Cloud: Integrating On-Premises SQL Server Backup and Recovery with Window Azure Timothy P. McAliley @sysframeworks Microsoft Premier Field Engineer – SQL Server
About NetCom Learning • • • • • • •
Microsoft’s 2007 Worldwide Training Partner of the Year Award Microsoft’s 2013 Top 3 Worldwide Training Partners Gold Training Partner for Microsoft Over 17 Vendor Recognitions NetCom Learning has trained over 80% of the Fortune 100 Helped advanced the skills of more than 71,000 professionals. Instructor evaluation score of 8.6 out of the 9 average.
www.NetComLearning.com
Our Purpose: To Promote the Values of Lifelong Learning
Our Mission: To Grow the Company Profitably Each Year by Becoming the Most Trusted Learning Organization.
Agenda
www.NetComLearning.com
Walkthrough and Demo
www.NetComLearning.com
Key Concepts and Fun Facts
www.NetComLearning.com
Key Concepts and Fun Facts
Windows Azure Blob Storage Service
www.NetComLearning.com
Key Concepts and Fun Facts
www.NetComLearning.com
Backup to Windows Azure
CREATE CREDENTIAL mystoragecred WITH IDENTITY = ‘mystorage', SECRET = ‘ BACKUP DATABASE mydb TO URL ='https://mystorage.blob.core.windows.net/backupcontainer/mydb-20130411.bak' WITH CREDENTIAL = ‘mystoragecred', FORMAT, COMPRESSION, STATS = 5, MEDIANAME = ‘mydb backup 20130411', MEDIADESCRIPTION = 'Backup of mydb'
Backup to Windows Azure
On-site/off-site storage costs Device management costs
•
Azure Drives limited to 1 terabyte Max 16 drives Manage drives and policy
• •
• • • • • •
Near “bottomless” storage Off-site, geo-redundant No provisioning No device management Media safety (decay-free) Remote accessibility
Windows Azure Blobs
• •
WA Box
Windows Azure storage
Backup to Windows Azure
Backup to Windows Azure Tool
Managed Backup to Azure • Agent that manages and automates SQL Server backup policy
• Large-scale management and no need to manage backup policy • • •
Context-aware – for example, workload/throttling Minimal knobs – control retention period Manage whole instance or particular databases
• Take advantage of backup to Azure • • • •
Inherently off-site Geo-redundant Minimal storage costs Zero hardware management
Example: EXEC smart_admin.sp_set_db_backup @database_name='TestDB', @storage_url=<storage url>, @retention_days=30, @credential_name='MyCredential', @enable_backup=1
Benefits
www.NetComLearning.com
“How To” Steps
www.NetComLearning.com
www.NetComLearning.com
Best Practices – Managing Backups
www.NetComLearning.com
Best Practices – Handling Large Files /Performance
www.NetComLearning.com
References and Resources http://azure.microsoft.com/en-us/
www.microsoft.com/sqlserver
http://technet.microsoft.com/en-us/sqlserver/default
www.NetComLearning.com
References and Resources
www.NetComLearning.com
Summary
www.NetComLearning.com
Our Purpose: To Promote the Values of Lifelong Learning
Our Mission: To Grow the Company Profitably Each Year by Becoming the Most Trusted Learning Organization.
www.NetComLearning.com
MCSA SQL Server 2012
MCSA: SQL Server 2012 Exam 70-461 (10774)
Exam 70-462 (10775)
Exam 70-463 (10777)
Querying Microsoft SQL Server 2012
Administering Microsoft SQL Server 2012 Databases
Implementing a Data Warehouse with Microsoft SQL Server 2012
Course Outline for MCSA: SQL Server 2012
www.netcomlearning.com
MCSE Data Platform
Course Outline for MCSE: Data Platform www.netcomlearning.com
MCSE Business Intelligence
Course Outline for MCSE: Business Intelligence
1-888-5-NETCOM (563-8266) [email protected] www.NetComLearning.com
About NetCom Learning • • • • • • •
Microsoft’s 2007 Worldwide Training Partner of the Year Award Microsoft’s 2013 Top 3 Worldwide Training Partners Gold Training Partner for Microsoft Over 17 Vendor Recognitions NetCom Learning has trained over 80% of the Fortune 100 Helped advanced the skills of more than 71,000 professionals. Instructor evaluation score of 8.6 out of the 9 average.
www.NetComLearning.com
Our Purpose: To Promote the Values of Lifelong Learning
Our Mission: To Grow the Company Profitably Each Year by Becoming the Most Trusted Learning Organization.
Agenda
www.NetComLearning.com
Walkthrough and Demo
www.NetComLearning.com
Key Concepts and Fun Facts
www.NetComLearning.com
Key Concepts and Fun Facts
Windows Azure Blob Storage Service
www.NetComLearning.com
Key Concepts and Fun Facts
www.NetComLearning.com
Backup to Windows Azure
CREATE CREDENTIAL mystoragecred WITH IDENTITY = ‘mystorage', SECRET = ‘ BACKUP DATABASE mydb TO URL ='https://mystorage.blob.core.windows.net/backupcontainer/mydb-20130411.bak' WITH CREDENTIAL = ‘mystoragecred', FORMAT, COMPRESSION, STATS = 5, MEDIANAME = ‘mydb backup 20130411', MEDIADESCRIPTION = 'Backup of mydb'
Backup to Windows Azure
On-site/off-site storage costs Device management costs
•
Azure Drives limited to 1 terabyte Max 16 drives Manage drives and policy
• •
• • • • • •
Near “bottomless” storage Off-site, geo-redundant No provisioning No device management Media safety (decay-free) Remote accessibility
Windows Azure Blobs
• •
WA Box
Windows Azure storage
Backup to Windows Azure
Backup to Windows Azure Tool
Managed Backup to Azure • Agent that manages and automates SQL Server backup policy
• Large-scale management and no need to manage backup policy • • •
Context-aware – for example, workload/throttling Minimal knobs – control retention period Manage whole instance or particular databases
• Take advantage of backup to Azure • • • •
Inherently off-site Geo-redundant Minimal storage costs Zero hardware management
Example: EXEC smart_admin.sp_set_db_backup @database_name='TestDB', @storage_url=<storage url>, @retention_days=30, @credential_name='MyCredential', @enable_backup=1
Benefits
www.NetComLearning.com
“How To” Steps
www.NetComLearning.com
www.NetComLearning.com
Best Practices – Managing Backups
www.NetComLearning.com
Best Practices – Handling Large Files /Performance
www.NetComLearning.com
References and Resources http://azure.microsoft.com/en-us/
www.microsoft.com/sqlserver
http://technet.microsoft.com/en-us/sqlserver/default
www.NetComLearning.com
References and Resources
www.NetComLearning.com
Summary
www.NetComLearning.com
Our Purpose: To Promote the Values of Lifelong Learning
Our Mission: To Grow the Company Profitably Each Year by Becoming the Most Trusted Learning Organization.
www.NetComLearning.com
MCSA SQL Server 2012
MCSA: SQL Server 2012 Exam 70-461 (10774)
Exam 70-462 (10775)
Exam 70-463 (10777)
Querying Microsoft SQL Server 2012
Administering Microsoft SQL Server 2012 Databases
Implementing a Data Warehouse with Microsoft SQL Server 2012
Course Outline for MCSA: SQL Server 2012
www.netcomlearning.com
MCSE Data Platform
Course Outline for MCSE: Data Platform www.netcomlearning.com
MCSE Business Intelligence
Course Outline for MCSE: Business Intelligence
1-888-5-NETCOM (563-8266) [email protected] www.NetComLearning.com
