Turgay Sahtiyan has been working in IT industry over a decade and he currently works as a Senior SQL Server Premier Field Engineer at Microsoft. He is based in Turkey and primarily giving proactive services to top enterprise customers in the MEA region. His main areas are Performance Tuning, HA&DR solutions, database administration and SQL Server 2012 Parallel Data Warehouse
Before joined to Microsoft, he was one of the SQL Server MVP in Turkey, in addition he is founder and former president of SQLPass Turkey Chapter. He is still on the leader team of SQLPass Turkey Chapter and still working with communities as being community leader by sharing his passion, technical expertise, and real-world knowledge of SQL Server with others.
Turgay regularly presents sessions at Microsoft and EMEA region SQLSaturday events. In addition he frequently blogs about SQL Server to his Turkish and English blogs
TR Blog : www.turgaysahtiyan.comEN Blog : http://blogs.msdn.com/b/turgays/Twitter : @turgaysahtiyanLinkedin : http://www.linkedin.com/pub/turgay-sahtiyan/15/b46/682
As all of you already awared, backing up data is a vitally important part of the strategy in protecting data loss due to disasters such as loosing data center completely. This article is not a pure disaster recovery article and not talks about disaster recovery strategies. In this article we are going to talk about a new cool feature comes with SQL Server 2012 SP1 + Cumulative Update 2 which is called “Backup to URL” and what the benefits of this feature are and how we can use it.
With SQL Server 2012 SP1 + Cumulative Update 2 you can back up to and restore from the Windows Azure Blob storage service directly by using T-SQL backup and restore statement. By using this feature you can easily backup your application databases to Windows Azure Blob Storage and provide a disaster recovery solution to your applications. You can use this article for additional information.
Below is the outline of the steps:
Create the Windows Azure Storage Account in Windows Azure
Create the Credential
CREATE CREDENTIAL mycredential WITH IDENTITY = 'sqlserverbackups' ,SECRET = '4DLmAKvFWpP9ptMgkySsoHOWB5uE2uBRzJxHP22z5GTDmk7AXodZO13gzGR1';
Back up the on-premise Database to Windows Azure Blob Storage
Restore the Database from Windows Azure Blob Storage
CREATE CREDENTIAL mycredential WITH IDENTITY = 'sqlserverbackups' ,SECRET = '4DLmAKvFWpP9ptMgkySsoHOWB5uE2uBRzJxHP22z5GTDmk7AXodZO13gzGR1+akJgXWynq9PkIdPNZxCsxeNxw==';
--Restore DB1 from backup in Windows Azure Blob Storage RESTORE DATABASE DB1 FROM URL = 'http://sqlserverbackups.blob.core.windows.net/backuptourldemo/DB1.bak' WITH CREDENTIAL = 'mycredential'
That’s it. We covered all steps you need to follow for using Windows Azure Blob Storage as database backup target.
As review, with SQL Server 2012 SP1 + Cumulative Update 2 you can back up to and restore from the Windows Azure Blob storage service directly by using T-SQL backup and restore statement. The steps you need to follow are;