September 3, 2010 at 12:29 am
Hi frds,
i have 50 tlog files ,how can i restore all tlogs?
is it possible to restore all tlog files at a time?
if any one knows plz give me answer
thanks
jayapal
September 5, 2010 at 12:44 am
Restore from transaction log backups. They should contain all the transactional changes since the last full backup.
Joie Andrew
"Since 1982"
September 5, 2010 at 12:51 pm
You need to restore the full backup first, then each log individually, in order. I would restore everything with NORECOVERY always, so that if there is a mistake or another file, you are safe and you can continue restoring.
Here's a script that may help: http://www.sqlservercentral.com/scripts/T-Log/69750/
September 5, 2010 at 1:42 pm
Sorry. Steve is absolutely correct. I was making an assumption about the full backup restore being done. The logs have to be restored in order, so it will be full, then the latest differential if any had been taken, then the tlog backups in order. Norecovery should be specified until the last trans log backup which will have recovery.
Joie Andrew
"Since 1982"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply