How to Make SQL Server Backups and Restores Faster

Every day, your servers do hundreds or thousands of operations that are all resource-intensive.  You want these operations to finish as quickly as possible, because they’re absolutely mission critical, and you’ll lose your job if they’re not done successfully.  Whole companies have been lost when these operations fail.  Yet do you really know how to make these operations happen faster?

These operations are backups and restores.

And no, most of us don’t know why they take so long.

In this five-minute video, I explain the only two surefire ways to improve your backup and restore performance: instant file initialization and cleaning your MSDB history.

To learn more, here’s related links for each of those techniques:

Previous Post
SQL Server Magazine’s Publisher Files Bankruptcy
Next Post
SQLSaturday Chicago Swag

10 Comments. Leave new

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}