sysopentapes-transact-sql.md

title	sysopentapes (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sysopentapes sysopentapes_TSQL
dev_langs	TSQL
helpviewer_keywords	backup media [SQL Server], sysopentapes system table sysopentapes system table
ms.assetid	c066ca9b-9cfd-46b1-90a3-5c8dc9e7b6ae
author	stevestein
ms.author	sstein

sysopentapes (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Contains one row for each currently open tape device. This view is stored in the master database.

Important

This system table is included as a view for backward compatibility. Instead, use the sys.dm_io_backup_tapes (Transact-SQL) dynamic management view.

Note

You cannot drop the sysopentapes view.

Column name	Data type	Description
openTape	nvarchar(64)	Physical file name of 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.