I have been trying to restore a database from full backup. It progress to 100% as expected. After that it gets stuck in the step "Restore: Waiting for log zero on <databasename>" and it is stuck there for ever. It doesn't seem normal at all. Has anyone faced a similar issue. It has been running like that for more than a day now and I am unable to proceed.
Backup size: 36 GB
Data file size: 250 gb
Log file size: 60 GB
Answer by Kev Riley ·
I would have expected a message like that to show that you are waiting on the log file being initialized (zeroed), but over a day to do 60GB is a little excessive! It could also be that the log file contained a lot of in-flight transactions, and so it's now in the recovery stage, working out which transactions to roll forward and which to roll back.
Do you have the output of sp_whoisactive (or similar) to give a clue as to what is actually processing?