SkipTapeHeader Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The SkipTapeHeader property enables or disables backup operation logic that verifies that correct media is loaded.
Syntax
object.SkipTapeHeader [= value]
Parts
object
An expression that evaluates to an object in the Applies To listvalue
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetSkipTapeHeader(LPBOOL pRetVal);
HRESULT SetSkipTapeHeader(BOOL NewValue);
Remarks
If TRUE, a media name recorded on the media is not checked. The backup set is appended to the media.
If FALSE, a recorded media name is checked. When using SQL Distributed Management Objects (SQL-DMO) to perform a backup, provide the media name using the MediaName property. FALSE is the default value.
Note
SQL-DMO implements backup media initialization using the Initialize property. If Initialize is TRUE, SkipTapeHeader enables or disables logic that prevents overwrite of unexpired backup sets on a media. For more information, see BACKUP (Transact-SQL).