Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Trying to restore a lost Server 2008 database. Had a backup from 2 weeks ago and were able to get the transaction log files. So I restored the DB in norecovery mode and started restoring the transactions log files since the full backup time. There are a couple of files for each day so I have a lot of files to apply and everything seems to going good except for one question. I have gone through a couple of transaction files but do not see the file size of the DB increasing? So I am worried the transactions files are not being applied. Is there another way to check if transaction log data is being recovered? I know I can't bring the DB online till I finish through all the transaction log files.

Thanks

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

The data file doesn't have to grow to incorporate the transaction log entries. It may do on later restores of course

The transactions are being applied if the restore is successful: and if the next one works too. And you have restored 2 which means the 1st was OK

The backup files have some internal information (LSN) that are compared on restore to the LSN of the database. They must match and you can't skip a restore. Based on this, you have confidence that previous restores are OK

share|improve this answer
    
Yes I figured that when I got to the 40th transaction log and it was corrupt. So I had to restart the restore process. –  Garfield81 Jul 3 '11 at 4:54
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.