PostEverything That Affects SQL Server Database Restore and Recovery

Have you ever wondered why your SQL Server database takes a long time to restore? How about why a failover of your Availability Groups, Failover Clustered Instances or even database mirroring configuration is taking a long time?  I know I have.

I’ve gone from querying the sys.dm_exec_requests DMV to check for the status and percentage of a RESTORE command to looking at the cluster error log to see how long it took to failover a resource group. But then I was trying to figure out what happened instead of understanding how it works. In this video, I talk about the different factors affecting restore and recovery of your SQL Server databases. Take the lessons that you’ll learn from this video to constantly evaluate whether or not your high availability and disaster recovery strategies still meet your recovery objectives and service level agreements.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close