title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.sysfiles (Transact-SQL) |
sys.sysfiles (Transact-SQL) |
rwestMSFT |
randolphwest |
03/15/2017 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Contains one row for each file in a database.
Important
[!INCLUDEssnoteCompView]
Column name | Data type | Description |
---|---|---|
fileid | smallint | File identification number unique for each database. |
groupid | smallint | File group identification number. |
size | int | Size of the file, in 8-KB pages. |
maxsize | int | Maximum file size, in 8-KB pages. 0 = No growth. -1 = File will grow until the disk is full. 268435456 = Log file will grow to a maximum size of 2 TB. Note: Databases that are upgraded with an unlimited log file size will report -1 for the maximum size of the log file. |
growth | int | Growth size of the database. Can be either the number of pages or the percentage of file size, depending on value of status. 0 = No growth. |
status | int | Status bits for the growth value in either megabytes (MB) or kilobytes (KB). 0x2 = Disk file. 0x40 = Log file. 0x100000 = Growth. This value is a percentage and not the number of pages. |
perf | int | Reserved. |
name | sysname | Logical name of the file. |
filename | nvarchar(260) | Name of the physical device. This includes the full path of the file. |
Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)