共用方式為


Restore.SqlVerifyLatest 方法 (Server, SqlVerifyAction, String%)

Verifies the most recent backup with the specified action, checks to see that the backup set is complete and the entire backup is readable, and returns an error message.

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

語法

'宣告
Public Function SqlVerifyLatest ( _
    srv As Server, _
    sqlVerifyAction As SqlVerifyAction, _
    <OutAttribute> ByRef errorMessage As String _
) As Boolean
'用途
Dim instance As Restore 
Dim srv As Server 
Dim sqlVerifyAction As SqlVerifyAction 
Dim errorMessage As String 
Dim returnValue As Boolean 

returnValue = instance.SqlVerifyLatest(srv, _
    sqlVerifyAction, errorMessage)
public bool SqlVerifyLatest(
    Server srv,
    SqlVerifyAction sqlVerifyAction,
    out string errorMessage
)
public:
bool SqlVerifyLatest(
    Server^ srv, 
    SqlVerifyAction sqlVerifyAction, 
    [OutAttribute] String^% errorMessage
)
member SqlVerifyLatest : 
        srv:Server * 
        sqlVerifyAction:SqlVerifyAction * 
        errorMessage:string byref -> bool
public function SqlVerifyLatest(
    srv : Server, 
    sqlVerifyAction : SqlVerifyAction, 
    errorMessage : String
) : boolean

參數

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

傳回值

型別:System.Boolean
A Boolean value that indicates whether targeted backup set is readable and complete.If True, the backup set was successfully verified. Otherwise, False.

範例

備份及還原資料庫和交易記錄

請參閱

參考

Restore 類別

SqlVerifyLatest 多載

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

RESTORE (Transact-SQL)

SQL Server 資料庫的備份與還原