Restore.SqlVerify Method (Server, Boolean, out String)

  • 發行項

Checks the media on the Microsoft SQL Server instance represented by the specified Server object, loads backup history information into the history tables, and returns an error message.

命名空間: Microsoft.SqlServer.Management.Smo
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

語法

'宣告
Public Function SqlVerify ( _
    srv As Server, _
    loadHistory As Boolean, _
    <OutAttribute> ByRef errorMessage As String _
) As Boolean

public bool SqlVerify (
    Server srv,
    bool loadHistory,
    out string errorMessage
)

public:
bool SqlVerify (
    Server^ srv, 
    bool loadHistory, 
    [OutAttribute] String^% errorMessage
)

public boolean SqlVerify (
    Server srv, 
    boolean loadHistory, 
    /** @attribute OutAttribute() */ /** @ref */ String errorMessage
)

JScript 不支援以傳址方式傳遞值類型的引數。

參數

  • srv
    A Server object that represents the SQL Server instance targeted by the restore operation.

  • loadHistory
    A Boolean value that specifies whether the history tables will be populated with pertinent backup information.

    If True, the history tables are populated.

    If False, the history tables are not populated.

  • errorMessage
    A String value that contains the error message when the method has completed running. This is an output parameter.

傳回值

A Boolean value indicating whether targeted backup set is readable and complete. If True, the backup set was successfully verified. If False, the attempt to verify the backup set was unsuccessful.

備註

只有 Microsoft .NET Framework 2.0 版支援此命名空間、類別或成員。

範例

How to: Back Up Databases and Transaction Logs in Visual Basic .NET

執行緒安全性

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

Restore Class
Restore Members
Microsoft.SqlServer.Management.Smo Namespace

其他資源

Backing Up and Restoring Databases and Transaction Logs
RESTORE (Transact-SQL)
在 SQL Server 中備份和還原資料庫