Restore taking long time with 0 bytes processed

scissorlad · February 8, 2017 5:41PM

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

petey · February 10, 2017 12:55AM

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.

scissorlad · February 10, 2017 1:52PM

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!

Restore taking long time with 0 bytes processed

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk