SkipTapeHeader Property
Questa caratteristica verrà rimossa a partire da una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The SkipTapeHeader property enables or disables backup operation logic that verifies that correct media is loaded.
Sintassi
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);
Osservazioni
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.
[!NOTA]
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).