Restore.SqlVerifyLatest Restore.SqlVerifyLatest Restore.SqlVerifyLatest Method

Definition

Verifies the most recent backup but does not restore it, and checks to see that the backup set is complete and the entire backup is readable.

Overloads

SqlVerifyLatest(Server, SqlVerifyAction, String) 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.

SqlVerifyLatest(Server, String) SqlVerifyLatest(Server, String) SqlVerifyLatest(Server, String)

Verifies the most recent backup but does not restore it, checks to see that the backup set is complete and the entire backup is readable, and returns an error message.

SqlVerifyLatest(Server, SqlVerifyAction) SqlVerifyLatest(Server, SqlVerifyAction)

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

SqlVerifyLatest(Server) SqlVerifyLatest(Server) SqlVerifyLatest(Server)

Verifies the most recent backup but does not restore it, and checks to see that the backup set is complete and the entire backup is readable.

SqlVerifyLatest(Server, SqlVerifyAction, String) 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.

public:
 bool SqlVerifyLatest(Microsoft::SqlServer::Management::Smo::Server ^ srv, Microsoft::SqlServer::Management::Smo::SqlVerifyAction sqlVerifyAction, [Runtime::InteropServices::Out] System::String ^ % errorMessage);
public bool SqlVerifyLatest (Microsoft.SqlServer.Management.Smo.Server srv, Microsoft.SqlServer.Management.Smo.SqlVerifyAction sqlVerifyAction, out string errorMessage);
Parameters
srv
Server Server Server

A Server object that represents the instance of SQL Server that is targeted by the restore operation.

sqlVerifyAction
SqlVerifyAction SqlVerifyAction SqlVerifyAction

A SqlVerifyAction value that specifies the type of backup to verify.

errorMessage
String String String

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

Returns

A Boolean value that indicates whether targeted backup set is readable and complete.

If True, the backup set was successfully verified. Otherwise, False.

Examples

Backing Up and Restoring Databases and Transaction Logs

SqlVerifyLatest(Server, String) SqlVerifyLatest(Server, String) SqlVerifyLatest(Server, String)

Verifies the most recent backup but does not restore it, checks to see that the backup set is complete and the entire backup is readable, and returns an error message.

public:
 bool SqlVerifyLatest(Microsoft::SqlServer::Management::Smo::Server ^ srv, [Runtime::InteropServices::Out] System::String ^ % errorMessage);
public bool SqlVerifyLatest (Microsoft.SqlServer.Management.Smo.Server srv, out string errorMessage);
Public Function SqlVerifyLatest (srv As Server, ByRef errorMessage As String) As Boolean
Parameters
srv
Server Server Server

A Server object that represents the instance of SQL Server that is targeted by the restore operation.

errorMessage
String String String

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

Returns

A Boolean value that indicates whether targeted backup set is readable and complete.

If True, the backup set was successfully verified. Otherwise, False.

Examples

Backing Up and Restoring Databases and Transaction Logs

SqlVerifyLatest(Server, SqlVerifyAction) SqlVerifyLatest(Server, SqlVerifyAction)

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

public:
 bool SqlVerifyLatest(Microsoft::SqlServer::Management::Smo::Server ^ srv, Microsoft::SqlServer::Management::Smo::SqlVerifyAction sqlVerifyAction);
public bool SqlVerifyLatest (Microsoft.SqlServer.Management.Smo.Server srv, Microsoft.SqlServer.Management.Smo.SqlVerifyAction sqlVerifyAction);
Parameters
srv
Server Server Server

A Server object that represents the instance of SQL Server that is targeted by the restore operation.

sqlVerifyAction
SqlVerifyAction SqlVerifyAction SqlVerifyAction

A SqlVerifyAction value that specifies the type of backup to verify.

Returns

A Boolean value that indicates whether targeted backup set is readable and complete.

If True, the backup set was successfully verified. Otherwise, False.

Examples

The following code example demonstrates how to create a backup of the AdventureWorks2012 database and verify that it is readable and complete without restoring.

VB

Dim srv As Server = New Server("(local)")  
Dim res As Restore = New Restore()  
Dim backup As Backup = New Backup()  

backup.Devices.AddDevice("C:\AdventureWorks2012Backup.bak", DeviceType.File)  
backup.Database = "AdventureWorks2012"  
backup.SqlBackup(srv)  

res.Devices.AddDevice("C:\AdventureWorks2012Backup.bak", DeviceType.File)  
res.Database = "AdventureWorks2012"  
Console.WriteLine(res.SqlVerifyLatest(srv, SqlVerifyAction.VerifyFile).ToString())  

Powershell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$res = new-object Microsoft.SqlServer.Management.Smo.Restore  
$backup = new-object Microsoft.SqlServer.Management.Smo.Backup  

$backup.Devices.AddDevice("C:\AdventureWorks2012Backup.bak", [Microsoft.SqlServer.Management.Smo.DeviceType]::File)  
$backup.Database = "AdventureWorks2012"  
$backup.SqlBackup($srv)  

$res.Devices.AddDevice("C:\AdventureWorks2012Backup.bak", [Microsoft.SqlServer.Management.Smo.DeviceType]::File)  
Write-Host $res.SqlVerifyLatest($srv, [Microsoft.SqlServer.Management.Smo.SqlVerifyAction]::VerifyFile)  

SqlVerifyLatest(Server) SqlVerifyLatest(Server) SqlVerifyLatest(Server)

Verifies the most recent backup but does not restore it, and checks to see that the backup set is complete and the entire backup is readable.

public:
 bool SqlVerifyLatest(Microsoft::SqlServer::Management::Smo::Server ^ srv);
public bool SqlVerifyLatest (Microsoft.SqlServer.Management.Smo.Server srv);
Public Function SqlVerifyLatest (srv As Server) As Boolean
Parameters
srv
Server Server Server

A Server object that represents the instance of SQL Server that is targeted by the restore operation.

Returns

A Boolean value that indicates whether the targeted backup set is readable and complete.

If True, the backup set was verified successfully. Otherwise, False.

Examples

The following code example demonstrates how to create a backup of the AdventureWorks2012 database and verify that it is readable and complete without restoring.

VB

Dim srv As Server = New Server("(local)")  
Dim res As Restore = New Restore()  
Dim backup As Backup = New Backup()  

backup.Devices.AddDevice("C:\AdventureWorks2012Backup.bak", DeviceType.File)  
backup.Database = "AdventureWorks2012"  
backup.SqlBackup(srv)  

res.Devices.AddDevice("C:\AdventureWorks2012Backup.bak", DeviceType.File)  
res.Database = "AdventureWorks2012"  
Console.WriteLine(res.SqlVerifyLatest(srv).ToString())  

Powershell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$res = new-object Microsoft.SqlServer.Management.Smo.Restore  
$backup = new-object Microsoft.SqlServer.Management.Smo.Backup  

$backup.Devices.AddDevice("C:\AdventureWorks2012Backup.bak", [Microsoft.SqlServer.Management.Smo.DeviceType]::File)  
$backup.Database = "AdventureWorks2012"  
$backup.SqlBackup($srv)  

$res.Devices.AddDevice("C:\AdventureWorks2012Backup.bak", [Microsoft.SqlServer.Management.Smo.DeviceType]::File)  
Write-Host $res.SqlVerifyLatest($srv)  

Applies to