Método Server.DeleteBackupHistory (String)
Deletes the backup history for the specified database.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)
Sintaxe
'Declaração
Public Sub DeleteBackupHistory ( _
database As String _
)
'Uso
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
)
Parâmetros
- database
Tipo: System.String
A String value that specifies the name of the database for which the backup history is deleted.
Comentários
Use this method to remove backup history logs for a specific database on the instance of SQL Server.
Exemplos
'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")
Consulte também
Referência
Sobrecarregado DeleteBackupHistory
Namespace Microsoft.SqlServer.Management.Smo