This topic has not yet been rated - Rate this topic

Server.DeleteBackupHistory Method

SQL Server 2012

SQL Server 2005

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

This member is overloaded. For complete information about this member, including syntax, usage, and examples, click a name in the overload list.

Overload List

	Name	Description
	DeleteBackupHistory(DateTime)	Deletes the backup history for this instance of SQL Server up until the specified date and time.
	DeleteBackupHistory(Int32)	Deletes the backup history for the specified media set.
	DeleteBackupHistory(String)	Deletes the backup history for the specified database.

Top

Remarks

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.

Reference

Server Class

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD