Export (0) Print
Expand All

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 string StandbyFile { get; set; }

Property Value

Type: 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"

Community Additions

ADD
Show:
© 2014 Microsoft