Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)
Syntax
'Declaration
Public Property StandbyFile As String
Get
Set
'Usage
Dim instance As Restore
Dim value As String
value = instance.StandbyFile
instance.StandbyFile = value
public string StandbyFile { get; set; }
public:
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.
Remarks
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.
Examples
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"
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace