Поделиться через

  • Статья

Свойство 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"