Transact-SQL Reference
sysopentapes
Contains one row for each currently open tape device. This view is stored in the master database.
| Column name | Data type | Description |
|---|---|---|
| openTape | nvarchar(64) NOT NULL |
Physical file name of open tape device. For more information about opening and releasing tape devices, see BACKUP and RESTORE. |