共用方式為

Backup.UndoFileName 屬性

  • 發行項

Gets or sets the name of the undo file used to store uncommitted transactions that are rolled back during recovery.

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.SmoExtended (在 Microsoft.SqlServer.SmoExtended.dll 中)

語法

'宣告
Public Property UndoFileName As String 
    Get 
    Set
'用途
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)

屬性值

型別：System.String
A String value that specifies the undo file name.

範例

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"

請參閱

參考

Backup 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

BACKUP (Transact-SQL)

備份及還原資料庫和交易記錄