Share via

  • 發行項

StandbyFile 屬性

Gets or sets the name of an undo file that is used as part of the imaging strategy for an instance of SQL Server.

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

語法

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

屬性值

型別：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.

範例

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:\AdventureWorks2008R22008R2Backup.bak"

PowerShell

$rs = new-object Microsoft.SqlServer.Management.Smo.Restore
$rs.StandbyFile = "C:\AdventureWorks2008R22008R2Backup.bak"