Restore::ClearSuspectPageTable Method (Server^)

 

Deletes entries in the suspect page table.

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

public:
void ClearSuspectPageTable(
	Server^ srv
)

Parameters

srv
Type: Microsoft.SqlServer.Management.Smo::Server^

The instance of SQL Server that is targeted by the restore operation.

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)
Return to top
Show: