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

PowerShell

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

참고 항목

참조

Restore 클래스

Microsoft.SqlServer.Management.Smo 네임스페이스

관련 자료

RESTORE(Transact-SQL)

SQL Server 데이터베이스 백업 및 복원