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 list

  • value
    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).

Applies To: