Restore.ClearSuspectPageTable-Methode

Deletes entries in the suspect page table.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)

Syntax

'Declaration
Public Sub ClearSuspectPageTable ( _
    srv As Server _
)
'Usage
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
)

Parameter

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

Beispiele

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)

Siehe auch

Verweis

Restore Klasse

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

RESTORE (Transact-SQL)

Sichern und Wiederherstellen von SQL Server-Datenbanken

Verwalten der suspect_pages-Tabelle (SQL Server)