NoRewind Property
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The NoRewind property specifies whether Microsoft SQL Server keeps a tape drive open and positioned after a backup or restore operation.
Sintaxis
object
.NoRewind [= 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 GetNoRewind(BOOL);
HRESULT SetNoRewind(BOOL);
Notas
If NoRewind is set to TRUE, SQL Distributed Management Objects (SQL-DMO) issues the Transaction-SQL BACKUP or RESTORE command with the NOREWIND option. This allows SQL Server 2000 to keep a tape drive open and positioned, thereby preventing the overhead of rewinding and scanning a tape. This is useful in situations where a tape is repeatedly used. NoRewind is set to FALSE by default.
[!NOTA] If an application calls NoRewind on an instance of SQL Server version 7.0, the operation is ignored.
Applies To:
Vea también
Otros recursos
BACKUP (Transact-SQL)
RESTORE (Transact-SQL)