Best practices for SQL Server backup maintenance

Friday Oct 12th 2007 by DatabaseJournal.com Staff
Share:

Part of your regular backup procedures should include removing old database backup history from the msdb database.

[From SearchSQLServer]

Part of your regular backup procedures should include removing old database backup history from the msdb database. That reduces the size of the msdb database and improves performance of the Enterprise Manager or Management Studio applications when you use them to restore.

The article continues at http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1275247,00.html

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved