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 the undo file used to store uncommitted transactions that are rolled back during recovery.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
Syntax
'Declaration
Public Property UndoFileName As String
Get
Set
'Usage
Dim instance As Backup
Dim value As String
value = instance.UndoFileName
instance.UndoFileName = value
public string UndoFileName { get; set; }
public:
property String^ UndoFileName {
String^ get ();
void set (String^ value);
}
member UndoFileName : string with get, set
function get UndoFileName () : String
function set UndoFileName (value : String)
Property Value
Type: System.String
A String value that specifies the undo file name.
Examples
VB
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2012 database.
Dim db As Database
db = srv.Databases("AdventureWorks2012")
Dim bk As New Backup
bk.Action = BackupActionType.Database
bk.Database = "AdventureWorks2012"
bk.UndoFileName = "C:\Program Files\Microsoft SQL Server\100\Samples\BackupAdventureWorks2012.mdf"
PowerShell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")
$bk = new-object Microsoft.SqlServer.Management.Smo.Backup
$bk.Action = [Microsoft.SqlServer.Management.Smo.BackupActionType]::Database
$bk.Database = "AdventureWorks2012"
$bk.UndoFileName = "C:\Program Files\Microsoft SQL Server\100\Samples\BackupAdventureWorks2012.mdf"
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace