Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Azure - Backup Expand / Collapse
Author
Message
Posted Wednesday, January 18, 2012 3:29 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, October 25, 2012 9:18 AM
Points: 522, Visits: 493
Hi all,

Does anybody know if it's possible to carry out a point-in-time restore of a SQL Azure DB? I've read various Technet articles but currently all I can see are the following options:

1.) Take a copy of the DB and name as something different
2.) Export out database to a BLOB file
3.) Use third party tools to synchronise schema/data between SQL Azure/SQL Server & vice versa.

This is based on my understanding from the following articles:

http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-backup-and-restore-strategy.aspx

http://blogs.msdn.com/b/davidmcg/archive/2011/09/29/data-backup-strategies-for-windows-and-sql-azure.aspx

I've been tasked with the feasibility study of this for a project that our firm is working on by moving some of our business functionality to the cloud.

Cheers,
Dan
Post #1237796
Posted Thursday, January 19, 2012 4:38 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, August 24, 2014 6:50 PM
Points: 401, Visits: 556
From one of the videos on Azure I've been watching there does seem to be a way to re-create a database in Azure at a point in time. I can't give you a reference at present.

I don't believe you can re-create the database outside Azure without using specialised tools (such as the one Reg-Gate has available - and no, I don't work for them!)
Post #1239139
Posted Wednesday, February 8, 2012 1:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 1:21 AM
Points: 268, Visits: 889
Hi Dan,

The only way you can create a 'backup' in SQL Azure is to either:

(A) Create a BACPAC using the tools in Azure itself. This isn't a real backup though, it seems to script the structure and the data and recreate it - so what comes back from the 'restore' is not identical in structure to what you backed up.

(B) Use a third party tool. The one I've used is Red Gate SQL Azure backup which is currently free. This will either front end option (A) or copy the database to a local instance using a prepacked version of SQL Compare / SQL Data Compare under the covers.

(C) If what you want to mitigate is your database accidently being mucked up by an application / user (rather than resilience) you can just copy the database to another one in SQL Azure.

If you want transactional integrity, you have to do option C first to guarantee consistency. Bear in mind though that there is no concept of a transaction log restore though, so you can't recover to a point in time.

Microsoft would say that the prospect of your database going down permanently in miniscule, and therefore that DBAs might worry too much about this!

Finally there are syntactical differences in Azure - you can't just ship any old SQL Server 2008 R2 database up there and expect it will definitely work!

Hope this helps.


.
Post #1248756
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse