Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Restore::StandbyFile Property

Gets or sets the name of an undo file that is used as part of the imaging strategy for an instance of SQL Server.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
public:
property String^ StandbyFile {
	String^ get ();
	void set (String^ value);
}

Property Value

Type: System::String
A String that specifies the name of the undo file.

Database log restoration with undo is available against a read-only image of a SQL Server database and offers one strategy for maintaining a standby image of critical instances.

The following code example sets the location of a backup file that can be used as an undo file for the database restore operation.

VB

Dim rs As Restore
rs = New Restore
rs.StandbyFile = "C:\AdventureWorks2012Backup.bak"

PowerShell

$rs = new-object Microsoft.SqlServer.Management.Smo.Restore
$rs.StandbyFile = "C:\AdventureWorks2012Backup.bak"
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.