Compartilhar via


Propriedade do RDL 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.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (em Microsoft.SqlServer.SmoExtended.dll)

Sintaxe

'Declaração
Public Property StandbyFile As String 
    Get 
    Set
'Uso
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)

Valor da propriedade

Tipo: System.String
A String that specifies the name of the undo file.

Comentários

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.

Exemplos

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"

Consulte também

Referência

Restore Classe

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

RESTORE (Transact-SQL)

Fazer backup e restaurar bancos de dados do SQL Server