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"
請參閱
參考
Microsoft.SqlServer.Management.Smo 命名空間