This topic has not yet been rated - Rate this topic

Server.DeleteBackupHistory Method (Int32)

SQL Server 2008 R2

Deletes the backup history for the specified media set.

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

Syntax

C++

JScript

public void DeleteBackupHistory(
	int mediaSetId
)

Parameters

mediaSetId: Type: System.Int32
An Int32 value that specifies the index number of the media set for which the backup history is deleted.

Remarks

Use this method to remove backup history logs for a media set on the instance of SQL Server. If a media set is being retired, then use this method to remove the backup history only for that media set.

Examples

Visual Basic

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server

'Delete backup history from the media set specified.
srv.DeleteBackupHistory(1)

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$srv.DeleteBackupHistory(1)

Reference

Server Class

DeleteBackupHistory Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Backing Up and Restoring Databases in SQL Server

Calling Methods

Managing Servers

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD