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"
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"