Restore.ClearSuspectPageTable 方法

Deletes entries in the suspect page table.

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.SmoExtended (在 Microsoft.SqlServer.SmoExtended.dll 中)

語法

'宣告
Public Sub ClearSuspectPageTable ( _
    srv As Server _
)
'用途
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
)

參數

• srv
  型別：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)

請參閱

參考

Restore 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

RESTORE (Transact-SQL)

SQL Server 資料庫的備份與還原

管理 suspect_pages 資料表 (SQL Server)