Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
Applies to: 
SQL Server
Contains one row for each currently open tape device. This view is stored in the master database.
Important
This system table appears as a view for backward compatibility. Instead, use the sys.dm_io_backup_tapes (Transact-SQL) dynamic management view.
Note
You can't drop the sysopentapes view.
Columns
| Column name | Data type | Description |
|---|---|---|
openTape |
nvarchar(64) |
Physical file name of an open tape device. For more information about opening and releasing tape devices, see BACKUP (Transact-SQL) and RESTORE (Transact-SQL). |
Permissions
The user needs VIEW SERVER STATE permission on the server.
Permissions for SQL Server 2022 and later
Requires VIEW SERVER PERFORMANCE STATE permission on the server.