January 18, 2012 at 3:29 am
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:
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
January 19, 2012 at 4:38 pm
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!)
February 8, 2012 at 1:30 am
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.
.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply