backup to the cloud: integrating on-premises sql …...backup to the cloud: integrating on-premises...

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

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

About NetCom Learning

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

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 = ‘<your storage access key> BACKUP DATABASE mydb TO URL ='https://mystorage.blob.core.windows.net/backup-container/mydb-20130411.bak' WITH CREDENTIAL = ‘mystoragecred', FORMAT, COMPRESSION, STATS = 5, MEDIANAME = ‘mydb backup 20130411', MEDIADESCRIPTION = 'Backup of mydb'

Backup to Windows Azure

Windows Azure

storage

WA

Win

do

ws

Azu

re

Blo

bs

• On-site/off-site storage costs

• Device management costs B

ox

• 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

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

http://azure.microsoft.com/en-us/

www.microsoft.com/sqlserver

http://technet.microsoft.com/en-us/sqlserver/default

References and Resources

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

Querying Microsoft SQL

Server 2012

Exam 70-461

(10774)

Administering Microsoft

SQL Server 2012

Databases

Exam 70-462

(10775)

MCSA: SQL Server 2012

Implementing a Data

Warehouse with Microsoft

SQL Server 2012

Exam 70-463

(10777)

www.netcomlearning.com

Course Outline for MCSA: SQL Server 2012

MCSE Data Platform

www.netcomlearning.com

Course Outline for MCSE: Data Platform

MCSE Business Intelligence

Course Outline for MCSE: Business Intelligence

1-888-5-NETCOM (563-8266)

info@netcomlearning.com

www.NetComLearning.com