RE: Restored Multiple Backup LOGS

andriancruz

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

petey

Restoring a chain of transaction logs in SQL Backup with just one script - pls see http://www.sqlbackuprestore.com/restoringachainoftransacti.htm

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

andriancruz

Thanks a lot! this is very helpful to me.

Regards, Andrian