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.