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 list
- value
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 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.
注意: |
---|
If an application calls NoRewind on an instance of SQL Server version 7.0, the operation is ignored. |
Applies To:
请参阅
其他资源
BACKUP (Transact-SQL)
RESTORE (Transact-SQL)