This topic has not yet been rated - Rate this topic

Server.DeleteBackupHistory Method (DateTime)

SQL Server 2012

SQL Server 2005

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)

Syntax

C++

JScript

public void DeleteBackupHistory(
	DateTime oldestDate
)

Parameters

oldestDate: Type: System.DateTime
A DateTime system object value that specifies the date and time before which to delete the backup history.

Remarks

Use this method to remove old backup history logs from the instance of SQL Server. Backup history that is older than the date specified will be removed from the instance of SQL Server.

Examples

Visual Basic

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

'Delete the backup history before the date specified.
Dim odt As DateTime
odt = New DateTime(2005, 12, 12)
srv1.DeleteBackupHistory(odt)

PowerShell

$srv1 = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$odt = new-object System.DateTime(2005, 12, 12)
$srv1.DeleteBackupHistory($odt)

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