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