samedi sql québec - database backup & copy to azure par eric moreau

Sauvegarde et copie de bases de

données SQL 2014 vers Azure

Éric Moreau, MVP

[email protected]

www.emoreau.com

mailto:[email protected]

http://www.emoreau.com/

Qui suis-je?

Consultant indépendant (Moer inc.)

MVP depuis juillet 2004

SQL User Group co-leader de Communauté des

développeurs Microsoft de Montréal (msdevmtl.com)

Je me spécialise dans le développement d’applications

.Net (VB et C#) utilisant MS SQL Server

http://www.msdevmtl.com/

Agenda

Faire une sauvegarde (backup) vers Azure

Récupérer un backup de Azure

Faire une copie d’une base de données vers SQL Azure

SQL Server 2014 Developer edition installé localement

Compte Azure

Mon environnement

Backup Databases to Windows Azure

Why Do We Need Cloud DR for SQL Server?

An event can cause on-premises

SQL Server to become unavailable

‐ Temporarily (e.g. gateway failure)

‐ Permanently (e.g. flooding)

A disaster recovery site is expensive

‐ Site rent + maintenance

‐ Hardware

‐ Ops

6

Typical configuration

7

Backup to Windows Azure

Windows Azure

storage

WA

• On-site/off-site storage costs

• Device management costsB

ox

• XDrives limited to 1 terabyte

• Max 16 drives

• Manage drives and policy

• Blobs

• Near “bottomless” storage

• Off-site, geo-redundant

• No provisioning

• No device management

• Media safety (decay-free)

• Remote accessibility


Restore GUI Backup GUI

Backup to Windows Azure Tools

Backing Up Through Windows Azure Tool

Benefits

Offers one-cloud backup strategy across previous versions of SQL Server, including 2005, 2008, and

2008 R2

Adds backup encryption to previous versions,

locally or in the cloud

Takes advantage of backup to Windows Azure

Easier to configure

http://www.microsoft.com/en-

us/download/details.aspx?id=40740

Windows Azure Tool is a standalone tool that adds backup capabilities to Windows Azure and backup encryption to previous versions of SQL Server

Demo for Backup Databases to Windows Azure


Win

do

ws

Azu

re B

lob

s

• Backing up to Azure is new to SQL

2014

• Taking a backup is easy

• Right-click your database

• Select Tasks

• Select Back Up …


• The Destination option

now let you pick URL

• Click the Add button


• Ensure the file name has a

.bak extension

• Otherwise, you will get

trouble restoring it!

• Set your credential

• Set the correct container


• Open the Options tab

• You can set the

compression

• You can set the

encryption

… or use PowerShell

… or .Net using SMO


This is why it is important to have .bak extensions


Deploy Databases to Windows Azure Wizard

Easy on-ramp to cloud

Hybrid Cloud Solutions

28

29

Key Benefits

Reduce project overhead

Speed time to market

Secure, redundant source

code

“Telenor saved 70% on test,

development and demo that could be

turned off when finished to minimize

their capital outlays,”

Marius Pedersen, Telenor Group

70% savings

Ready in hours, not weeks

Noresource

limits

SQL Server Dev Tools On-Premises

Development Work Stations

SQL Server

On-Premises

Deploy

SQL Server in a

Windows Azure

Virtual Machine

Test

TFS in Windows Azure

What is SQL Database?A relational database-as-a-service, fully managed by Microsoft.

For cloud-designed apps when near-zero administration and enterprise-grade capabilities are key.

Perfect for organizations looking to dramatically increase the DB:IT ratio.

Best for…

TCO

benefits

SQL Server in a VM Azure SQL Database

Scalability

Resources

SQL Database – ready for business-class apps

Increased from 99.9% to 99.99% uptime SLA

New service design point enables scale up of resources, delivering

predictable throughput & performance

SLA

Performance

Point-in-time-restore, geo-restore, and standard and active geo-

replication protect against human & environmental-initiated events

Azure certifications: ISO, HIPAA BAA, EU Model Clause

Auditing on SQL Database

Protection

Compliance

Hourly billing & broad set of price pointsFlexibility

*The 99.99% availability SLA does not apply to the existing Web and Business editions, which will continue to be supported at 99.9% availability.

here

http://technet.microsoft.com/en-us/evalcenter/dn800591

Demo for Deploy Databases to Windows Azure Wizard

Deploy DB to Windows Azure

Win

do

ws

Azu

re

Blo

bs

• To deploy a database to Windows

Azure:

• Right-click the database

• Select Tasks

• Select Deploy Database to

Windows Azure SQL Database

• Notice that a similar wizard exists to

deploy to a VM

• Click Next on the

Welcome dialog


• You first need to connect to the

target (Azure)


• Specify:

• Database name

• Edition of database

• Size of database


• Review the settings

and click Finish


• All green!!!


• If anything went wrong…


• Now that you have a database in

Azure

• You can use your local SSMS to

connect to it

• Connect to server

• Ensure your IP address is trusted

in the Azure management console


• Right-clicking an

Azure table in

SSMS

• Anything missing?


Wrap up

Sauvegarde et copie de bases de

données SQL 2014 vers Azure

Éric Moreau, MVP

[email protected]

www.emoreau.com

mailto:[email protected]

http://www.emoreau.com/

samedi sql québec - database backup & copy to azure par eric moreau

Technology