문서를 영문으로 보려면 영문 확인란을 선택하세요. 마우스 포인터를 텍스트 위로 이동시켜 팝업 창에서 영문 텍스트를 표시할 수도 있습니다.
번역
영문

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 bool SkipTapeHeader { get; set; }

속성 값

유형: 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

커뮤니티 추가 항목

추가
표시: