sys.sysdevices

Description

Contains one row for each disk backup file, tape backup file, and database file. Logical name of the backup file or database file. Size of the file in 2-kilobyte (KB) pages. Maintained for backward compatibility only. Maintained for backward compatibility only. Bitmap indicating the type of device: This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead.