Restore.ClearSuspectPageTable Method

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
)

Parameters

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

Examples

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)

See Also

Reference

Restore Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

RESTORE (Transact-SQL)

Back Up and Restore of SQL Server Databases

Manage the suspect_pages Table (SQL Server)