Méthode Restore.ClearSuspectPageTable

Deletes entries in the suspect page table.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.SmoExtended (en Microsoft.SqlServer.SmoExtended.dll)

Syntaxe

'Déclaration
Public Sub ClearSuspectPageTable ( _
    srv As Server _
)
'Utilisation
Dim instance As Restore 
Dim srv As Server

instance.ClearSuspectPageTable(srv)

public void ClearSuspectPageTable(
    Server srv
)

public:
void ClearSuspectPageTable(
    Server^ srv
)

member ClearSuspectPageTable : 
        srv:Server -> unit

public function ClearSuspectPageTable(
    srv : Server
)

Paramètres

• srv
  Type : Microsoft.SqlServer.Management.Smo.Server
  The instance of SQL Server that is targeted by the restore operation.

Exemples

The following code example deletes all entries in the restore suspect page table.

VB

Dim srv As Server
srv = New Server
Dim rs As Restore
rs = New Restore
rs.ClearSuspectPageTable(srv)

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$rs = new-object Microsoft.SqlServer.Management.Smo.Restore
$rs.ClearSuspectPageTable($srv)

Voir aussi

Référence

Restore Classe

Espace de noms Microsoft.SqlServer.Management.Smo

Autres ressources

RESTORE (Transact-SQL)

Sauvegarde et restauration des bases de données SQL Server

Gérer la table suspect_pages (SQL Server)