Export (0) Print
Expand All

Restore.SqlVerifyLatest Method

 

Applies To: SQL Server 2016 Preview

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.

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

NameDescription
System_CAPS_pubmethodSqlVerifyLatest(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.

System_CAPS_pubmethodSqlVerifyLatest(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.

System_CAPS_pubmethodSqlVerifyLatest(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.

System_CAPS_pubmethodSqlVerifyLatest(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.

Return to top

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

Parameters

srv
Type: Microsoft.SqlServer.Management.Smo.Server

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

Return Value

Type: System.Boolean

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

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

Legacy Code Example

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)
Return to top

Restore.SqlVerifyLatest Method (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(
	Server srv,
	SqlVerifyAction sqlVerifyAction
)

Parameters

srv
Type: Microsoft.SqlServer.Management.Smo.Server

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

sqlVerifyAction
Type: Microsoft.SqlServer.Management.Smo.SqlVerifyAction

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

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.

Legacy Code Example

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)
Return to top

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.

public bool SqlVerifyLatest(
	Server srv,
	SqlVerifyAction sqlVerifyAction,
	out string errorMessage
)

Parameters

srv
Type: Microsoft.SqlServer.Management.Smo.Server

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

sqlVerifyAction
Type: Microsoft.SqlServer.Management.Smo.SqlVerifyAction

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

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.

Return to top

Restore.SqlVerifyLatest Method (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(
	Server srv,
	out string errorMessage
)

Parameters

srv
Type: Microsoft.SqlServer.Management.Smo.Server

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

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.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft