• Article

Restore.SqlVerifyLatest Method (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.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)

Syntax

'Declaration
Public Function SqlVerifyLatest ( _
    srv As Server, _
    sqlVerifyAction As SqlVerifyAction, _
    <OutAttribute> ByRef errorMessage As String _
) As Boolean
'Usage
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

Parameters

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

Return Value

Type: 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.