Server.DeleteBackupHistory Method (String)
Deletes the backup history for the specified database.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Sub DeleteBackupHistory ( _
database As String _
)
'Usage
Dim instance As Server
Dim database As String
instance.DeleteBackupHistory(database)
public void DeleteBackupHistory(
string database
)
public:
void DeleteBackupHistory(
String^ database
)
member DeleteBackupHistory :
database:string -> unit
public function DeleteBackupHistory(
database : String
)
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")
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace