SkipTapeHeader Property
TOC
Collapse the table of content
Expand the table of content

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.


object
.SkipTapeHeader [= value]

object

An expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Boolean

Read/write

HRESULT GetSkipTapeHeader(LPBOOL pRetVal);
HRESULT SetSkipTapeHeader(BOOL NewValue);

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.

ms133524.note(en-US,SQL.90).gifNote:
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).

Community Additions

ADD
Show:
© 2016 Microsoft