Sql Server Restoring Process Time Takes Too Long Time 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?
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.