Share via


将SQL Server数据库备份到Windows Azure存储(Blob Storage)

?????Windows Azure????SQL Server????????,?????SQL Server??????(On-promise)?Windows Azure???????AlwaysOn?Database Mirroring?Log Shipping????????

??????????Windows Azure??????,??,???????Windows Azure????????????????(Data Disk)?16?,??????????1TB,????16TB?

????????????,????????????????,???????????,??????????

 

????,Windows Azure Blob Storage????????;??,??????Windows Azure?????????,?????????????,?????????????????/???????????????????,???????????Windows Azure??,???????????????

 

?????SQL Server 2012 Service Pack 1?CU2???(Cumulative update package 2)?,????SQL Server??????Windows Azure??(Blob Storage)?,????????

????????????,????TSQL?C#?PowerShell???,??Blob Storage?Url???(Credential)??????,??????(WITH COMPRESSION)??,???????????

 

Cumulative update package 2 for SQL Server 2012 Service Pack 1?????:

https://support.microsoft.com/kb/2790947

 

??,?????CodePlex??????:Microsoft SQL Server To Windows Azure helper library,??????????SQL Server Transact-SQL?Windows Azure???

https://sqlservertoazure.codeplex.com/

 

??,????????SQL Server 2014,????????????:

https://blogs.msdn.com/b/igorpag/archive/2013/10/23/create-a-sql-server-2014-database-directly-on-azure-blob-storage-with-sqlxi.aspx