Restore

Question

Restore

ramyours2003

SSChampion

Points: 12268
More actions
April 7, 2016 at 12:31 am

#326311

I have 600 GB of backup file , i need to restore the backup in less time. How can we restore the file ?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Short of replacing your IO subsystem with something faster, there's nothing you can really do.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 2

Check the setting of the server level option "backup compression". If it is off, change it to on.

Also check if your backup scripts use the default server option for backup compression. Either ensure they explicitly state to use compression, or use the default server option.

Compressing and decompressing the backup incurs a little CPU overhead, but the speed of the restore process is mostly determined by IO, not by CPU, so the space savings will result in an overall faster restore. (And a faster backup as well, and some disk space savings)

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 3

If appropriate for your environment, check that Instant File Initialization is enabled.

https://www.brentozar.com/blitz/instant-file-initialization/

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 4

Take a look at this article hope this will help you out:

http://henkvandervalk.com/how-to-increase-the-sql-database-restore-speed-using-db-compression-and-solid-state-disks