NoRewind Property
The NoRewind property specifies whether Microsoft® SQL Server™ 2000 keeps a tape drive open and positioned after a backup or restore operation.
| Backup2 Object | Restore2 Object |
Syntax
object.NoRewind [= value]
Parts
object
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);
Remarks
When NoRewind is set to TRUE, 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.
Note If an application calls NoRewind on an instance of SQL Server version 7.0, the operation is ignored.