Proprietà 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.
Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
Sintassi
'Dichiarazione
Public Property StandbyFile As String
Get
Set
'Utilizzo
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)
Valore proprietà
Tipo: System.String
A String that specifies the name of the undo file.
Osservazioni
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.
Esempi
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"
Vedere anche
Riferimento
Spazio dei nomi Microsoft.SqlServer.Management.Smo