How can we help you today? How can we help you today?

Restore taking long time with 0 bytes processed

Hi Red Gate folks,

I'm restoring what i imagine would be considered a large database (590GB ...60GB log)

It's been running for about 5hrs now and the status states o B processed

I found the slow restore issues documentation on the RED Gate site
https://documentation.red-gate.com/display/SBU7/Slow+backup+or+restore+operations#Slowbackuporrestoreoperations-SQLServerprocesses

Database Login Processed (bytes) Compressed (bytes)
TritonEmergencyRestore Administrator 0 22022144


Does this behavior seem normal? Do I simply need to wait?

Thanks for any advice
scissorlad
0

Comments

2 comments

Sort by
  • petey
    During a restore, SQL Server needs to create and size the data and log files. If instant initialization is active, it won't need to zero-ise the data files. Please see https://msdn.microsoft.com/en-us/librar ... 2147217396 for further details.
    petey
    0
  • scissorlad
    Thanks Peter. I didn;t know about Database Instant File Initialization!
    Just for closure.....the Restore did work just fine took and 10.5 hrs just as a data point. Thanks for the response!
    scissorlad
    0

Add comment

Please sign in to leave a comment.