This topic has not yet been rated - Rate this topic

Server.DeleteBackupHistory Method (String)

SQL Server 2012

Deletes the backup history for the specified database.

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

Syntax

C++

JScript

'Declaration
Public Sub DeleteBackupHistory ( _
	database As String _
)
'Usage
Dim instance As Server 
Dim database As String

instance.DeleteBackupHistory(database)

Parameters

database: Type: System.String
A String value that specifies the name of the database for which the backup history is deleted.

Remarks

Use this method to remove backup history logs for a specific database on the instance of SQL Server.

Examples

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

'Delete backup history from the database specified.
srv.DeleteBackupHistory("AdventureWorks2012")

PowerShell

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

Reference

Server Class

DeleteBackupHistory Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Back Up and Restore of SQL Server Databases

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