July 29, 2013 at 1:42 pm
We are running SQL Server 2012 SP1 64-Bit EE on Windows Server 2008 R2 SP1. We are taking a full backup on Sunday night, a diff backup Monday through Saturday night, and trans log backups Monday through Friday every 10 minutes from 7 A.M. to 6 P.M. If we have to recover the database at 5 P.M. (for Monday through Friday), then we would have to manually run a restore of the tlogs for every 10 minutes up until 5 P.M. That would be about 60 restore commands to restore all tlog backups between 7 A.M. and 5 P.M.
With SQL Server, is there a way to automatically restore multiple or a group of tlog backups? (Oracle automatically recovers a large number of archive logs with RECOVER DATABASE USING BACKUP CONTROL FILE UNTIL CANCEL;).
Thanks in advance, Kevin
July 30, 2013 at 8:14 am
No, you'd need to script it. But, if you have a fairly consistent naming or storage mechanism you should be able to script the scripting, write dynamic T-SQL to build the restore commands for you. I've done that in the past.
You can use the GUI to point it at a set of files and designate a point in time. It will then generate scripts you can use. Go to the Restore window and look for the Timeline button. It'll help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply