Server.DeleteBackupHistory Method

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

Remarks

Updated text:

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.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Overload List

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

See Also

Reference

Server Class
Server Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

How to: Use an SMO Method with a Parameter in Visual Basic .NET
Backing Up and Restoring Databases in SQL Server
Calling Methods
Managing Servers

Change History

Release

History

New content:
  • Added code sample to the Example section.

  • Added to the description in the Remarks section.