Sql-server – Sql Server Restoring Process Time Takes Too Long Time

backuprestoresql serversql-server-2016

I have 7 databases on my reporting server. I restore those databases every night with differetial backups. Normally, the differential restore time was taking about 1 or 1.5 hour for each databases. Last day, my restore process took so much long time. 4 of those databases has restored about 11 hours. The other one was completed normally. What can cause those databases to take such a long restoring time?

Best Answer

As long as you state that you did restore before and it took much less time I would quess that some of the following could be the reason:

  • some other process on the reporting server taking a lot of resources (in- and outside of SQL Server), that put high load on disks;
  • slow network connection between backups and reporting server if backups are located on a network share;
  • some process loading the disks with backups preventing fast reading of them by SQL Server.
Related Question