Mount Tape Event Class
The Mount Tape event class occurs when a tape mount request is received. Use this event class to monitor tape mount requests and their success or failure.
Mount Tape Event Class Data Columns
| Data column name | Data type | Description | Column ID | Filterable |
|---|---|---|---|---|
| ApplicationName | nvarchar |
Name of the client application that created the connection to an instance of SQL Server. This column is populated with the values passed by the application. | 10 | Yes |
| ClientProcessID | int |
ID assigned by the host computer to the process where the client application is running. This data column is populated if the client provides the client process ID. | 9 | Yes |
| DatabaseID | int |
ID of the database specified by the USE database statement or the default database if no USE database statement has been issued for a specified instance. SQL Server displays the name of the database if the ServerName data column is captured in the trace and the server is available. Determine the value for a database by using the DB_ID function. | 3 | Yes |
| DatabaseName | nvarchar |
Name of the database in which the user statement is running. | 35 | Yes |
| Duration | bigint |
Amount of time (in microseconds) taken by the event. | 13 | Yes |
| EndTime | datetime |
For Mount Request events, the time of the mount time-out if a time-out occurs; otherwise, the time of the event itself (in such cases, StartTime indicates the time of the corresponding mount request). | 15 | Yes |
| EventClass | int |
Type of event = 195. | 27 | No |
| EventSequence | int |
The sequence of a specified event within the request. | 51 | No |
| EventSubClass | int |
Type of event subclass. 1 = Tape mount request 2 = Tape mount complete 3 = Tape mount canceled |
21 | Yes |
| GroupID | int |
ID of the workload group where the SQL Trace event fires. | 66 | Yes |
| HostName | nvarchar |
Name of the computer on which the client is running. This data column is populated if the client provides the host name. To determine the host name, use the HOST_NAME function. | 8 | Yes |
| IsSystem | int |
Indicates whether the event occurred on a system process or a user process. 1 = system, 0 = user. | 60 | Yes |
| LoginName | nvarchar |
Name of the login of the user (either SQL Server security login or the Microsoft Windows login credentials in the form of DOMAIN\username). | 11 | Yes |
| NTDomainName | nvarchar |
Windows domain to which the user belongs. | 7 | Yes |
| NTUserName | nvarchar |
Windows user name. | 6 | Yes |
| ServerName | nvarchar |
Name of the instance of SQL Server being traced. | 26 | No |
| SessionLoginName | nvarchar |
Login name of the user who originated the session. For example, if you connect to SQL Server using Login1 and execute a statement as Login2, SessionLoginName shows Login1 and LoginName shows Login2. This column displays both SQL Server and Windows logins. | 64 | Yes |
| SPID | int |
ID of the Session on which the event occurred. | 12 | Yes |
| StartTime | datetime |
Time at which the event started, if available. | 14 | Yes |
| TextData | ntext |
physical device name [ ( logical device name ) ]. The logical device name displays only if it is defined in the sys.backup_devices catalog view. | 1 | Yes |
See Also
sp_trace_setevent (Transact-SQL)
Back Up and Restore of SQL Server Databases