RE: Restored Multiple Backup LOGS
andriancruz
Posts: 22
Hi All,
I'd just want to ask, if there is a simple way to restored multiple backup logs using scripts?
Here are my scenario. After I've restored the FULL and DIFFERENTIAL backup with NO RECOVERY option using scripts. I'd just want to restore next the transactional logs backup. but the problem was, since my transactional logs backup was scheduled every 10 mins and it will produced many transactional logs backup files. For instance, I need to restored roughly 200 transactional backup logs file, do I need to create 200 restore log scripts to apply those transaction logs backup?
is there any way to achieved this things without creating too much scripts?
Any comments/suggestion are highly appreciated.
Regards, Andrian
I'd just want to ask, if there is a simple way to restored multiple backup logs using scripts?
Here are my scenario. After I've restored the FULL and DIFFERENTIAL backup with NO RECOVERY option using scripts. I'd just want to restore next the transactional logs backup. but the problem was, since my transactional logs backup was scheduled every 10 mins and it will produced many transactional logs backup files. For instance, I need to restored roughly 200 transactional backup logs file, do I need to create 200 restore log scripts to apply those transaction logs backup?
is there any way to achieved this things without creating too much scripts?
Any comments/suggestion are highly appreciated.
Regards, Andrian
Comments
Restoring a database to its latest possible state using all available SQL Backup backup files (full, differential, transaction logs) with just one script - see http://www.sqlbackuprestore.com/restoringtothelatestpossib.htm
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
Regards, Andrian