Delete or Cleanup Backup History in sql server.


All backup history is stored in msdb database.

The following stored procedure can be executed with the parameter, here we clean history before 30 days.   

USE msdb
GO
DECLARE 
@BeforeDays DATETIME
SET 
@BeforeDays = CONVERT(VARCHAR(10), DATEADD(dd, -30,GETDATE()), 101)
EXEC 
sp_delete_backuphistory @BeforeDays
GO


 how to enable prevent save changes in SQL Server?

Go into Tools -> Options -> Designers-> Uncheck "Prevent saving changes that require table re-creation"

Related Posts

Fatal Error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails.

Problem: Sometimes, we get the following error when trying to make a connection in Rails.  FATAL ERROR: Peer authentication failed for us...