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 StandbyFile As String
Dim instance As Restore
Dim value As String

value = instance.StandbyFile

instance.StandbyFile = value
public string StandbyFile { get; set; }
property String^ StandbyFile {
    String^ get ();
    void set (String^ value);
member StandbyFile : string with get, set
function get StandbyFile () : String
function set StandbyFile (value : String)

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.