| title | sys.sysfiles (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/15/2017 | ||||
| ms.prod | sql-non-specified | ||||
| ms.reviewer | |||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 3b47f38d-1cff-404d-89d3-9342c451c802 | ||||
| caps.latest.revision | 40 | ||||
| author | BYHAM | ||||
| ms.author | rickbyh | ||||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Contains one row for each file in a database.
Important
[!INCLUDEssnoteCompView]
| Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version). |
| 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)