The NoRewind property specifies whether Microsoft® SQL Server™ 2000 keeps a tape drive open and positioned after a backup or restore operation.
object.NoRewind [= value]
Expression that evaluates to an object in the Applies To list
TRUE or FALSE
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.