NoRewind Property
В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.
The NoRewind property specifies whether Microsoft SQL Server keeps a tape drive open and positioned after a backup or restore operation.
Синтаксис
object
.NoRewind [= 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 GetNoRewind(BOOL);
HRESULT SetNoRewind(BOOL);
Замечания
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 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.
.gif "Примечание") Примечание |
|---|
If an application calls NoRewind on an instance of SQL Server version 7.0, the operation is ignored. |