April 19, 2010 at 1:12 pm
Hello Friends,
I have a question. I have a database of size 500GB and DR strategy for that is
(1) Full back up for weekend
(2) Diff back up on every day
(3) Log bck up on every 1/2 hr
The application team had asked me to get the latest copy of the database at 12:45PM (BY this time some important updates will occur, so the app team wants the latest copy of the database at this time) for some testing purpose. If I use from database back up, I have to get the tail log back up and then use full back up and then diff and then T.Log back up and I am wondering if that interurps the normal DR process. If I use full database back up database with copy_only option that it will take long time since the database size is 500GB.
So My question is is there any other method to complet this task as quickely as possible.
Thank you all for your support
April 19, 2010 at 2:18 pm
why not use the full backup from the weekend, the last diff backup before 12:45, and whatever log backups you need to get to 12:45, using the stopat clause with the last log.
you could take an extra diff backup to reduce the number of logs to restore.
---------------------------------------------------------------------
April 19, 2010 at 2:56 pm
Hello,
U r correct, thats the prefered method, but in that method we have to take tail log backup so I am just wondering if it interupts the users to conncet and access the database.
April 19, 2010 at 3:06 pm
You could just wait until the first t-log backup taken after 12:45 PM. You are taking them every 30 minutes.
April 20, 2010 at 3:25 am
mpalaparthi (4/19/2010)
Hello,U r correct, thats the prefered method, but in that method we have to take tail log backup so I am just wondering if it interupts the users to conncet and access the database.
you don't need to take a tail log backup, normal log backup from you normal log backup schedule will do.
---------------------------------------------------------------------
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply