Database Reference
In-Depth Information
Listing 30-24. Backup to and restore from Windows Azure Blob Storage
CREATE CREDENTIAL mycredential
WITH IDENTITY = 'mystorageaccount', SECRET = '<Secret Key>';
BACKUP DATABASE MyDB
TO URL =
'https://mystorageaccount.blob.core.windows.net/mycontainer/MyDB.bak'
WITH CREDENTIAL = 'mycredential', STATS = 5;
RESTORE DATABASE MyDB
FROM URL =
'https://mystorageaccount.blob.core.windows.net/mycontainer/db.bak'
WITH CREDENTIAL = 'mycredential', RECOVERY, STATS = 5;
2.
Alternatively, you can use Microsoft SQL Server Backup to Microsoft Windows Azure Tool ,
which will work with any version and edition of SQL Server. This tool works separately
from SQL Server. It intercepts backup files writing to the folders based on the specified
rules, and it uploads files to Azure Blob Storage. You can see a configuration of this utility
in Figure 30-10 .
Figure 30-10. Microsoft SQL Server Backup to Microsoft Windows Azure Tool
 
Search WWH ::




Custom Search