SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Azure - Backup


SQL Azure - Backup

Author
Message
Danb7183
Danb7183
Mr or Mrs. 500
Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)

Group: General Forum Members
Points: 576 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
Toby Harman
Toby Harman
Say Hey Kid
Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)Say Hey Kid (691 reputation)

Group: General Forum Members
Points: 691 Visits: 668
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!)
Tim Walker.
Tim Walker.
Mr or Mrs. 500
Mr or Mrs. 500 (525 reputation)Mr or Mrs. 500 (525 reputation)Mr or Mrs. 500 (525 reputation)Mr or Mrs. 500 (525 reputation)Mr or Mrs. 500 (525 reputation)Mr or Mrs. 500 (525 reputation)Mr or Mrs. 500 (525 reputation)Mr or Mrs. 500 (525 reputation)

Group: General Forum Members
Points: 525 Visits: 984
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.

.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search