Wednesday, March 25, 2015

Delete backup history and Errorlog

use msdb go exec sp_delete_backuphistory '2015-01-01' This will delete all records prior to 2015 go exec sp_cycle_errorlog This will create a new Error log file