dcsimg
 

Best practices for SQL Server backup maintenance

Friday Oct 12th 2007 by DatabaseJournal.com Staff

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

Home
Mobile Site | Full Site