共用方式為


Backup.SkipTapeHeader 屬性

Gets or sets Boolean property that determines whether the tape header is read.

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.SmoExtended (在 Microsoft.SqlServer.SmoExtended.dll 中)

語法

'宣告
Public Property SkipTapeHeader As Boolean 
    Get 
    Set
'用途
Dim instance As Backup 
Dim value As Boolean 

value = instance.SkipTapeHeader

instance.SkipTapeHeader = value
public bool SkipTapeHeader { get; set; }
public:
property bool SkipTapeHeader {
    bool get ();
    void set (bool value);
}
member SkipTapeHeader : bool with get, set
function get SkipTapeHeader () : boolean 
function set SkipTapeHeader (value : boolean)

屬性值

型別:System.Boolean
A Boolean value that specifies whether the tape header is read.If True, a media name recorded on the medium is not selected. The backup set is appended to the medium.If False (default), a recorded media name is selected.

備註

SMO implements backup media initialization using the Initializeproperty. When Initialize is True, SkipTapeHeader enables or disables logic that prevents overwrite of unexpired backup sets on a medium.

範例

VB

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2012 database.
Dim db As Database
db = srv.Databases("AdventureWorks2012")
Dim bk As New Backup
bk.Action = BackupActionType.Database
bk.Database = "AdventureWorks2012"
bk.SkipTapeHeader = true

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")
$bk = new-object Microsoft.SqlServer.Management.Smo.Backup
$bk.Action = [Microsoft.SqlServer.Management.Smo.BackupActionType]::Database
$bk.Database = "AdventureWorks2012"
$bk.SkipTapeHeader = $TRUE

請參閱

參考

Backup 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

BACKUP (Transact-SQL)

備份及還原資料庫和交易記錄