Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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