TechNet
Export (0) Print
Expand All

Server.DeleteBackupHistory Method

 

Deletes the backup history for this instance of SQL Server up until the specified date and time.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubmethodDeleteBackupHistory(DateTime)

Deletes the backup history for this instance of SQL Server up until the specified date and time.

System_CAPS_pubmethodDeleteBackupHistory(Int32)

Deletes the backup history for the specified media set.

System_CAPS_pubmethodDeleteBackupHistory(String)

Deletes the backup history for the specified database.

This method has three overloads that let you delete the backup history that is stored on the instance of SQL Server. You can do this by specifying a cutoff date, a media set, the name of a database.

Return to top
Show:
© 2016 Microsoft