Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Restore.ClearSuspectPageTable Method

Deletes entries in the suspect page table.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
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.

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)
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.