2013. 2. 5. 11:28
Brain Trainning/DataBase
2000 버전에서의 Sysfiles 정보
Contains one row for each file in a database. This system table is a virtual table; it cannot be updated or modified directly.
Column name | Data type | Description |
---|---|---|
fileid | smallint | File identification number unique for each database. |
groupid | smallint | Filegroup identification number. |
size | int | Size of the file (in 8-KB pages). |
maxsize | int | Maximum file size (in 8-KB pages). A value of 0 indicates no growth, and a value of -1 indicates that the file should grow until the disk is full. |
growth | int | Growth size of the database. A value of 0 indicates no growth. Can be either the number of pages or the percentage of file size, depending on value of status. If status contains 0x100000, then growthis the percentage of file size; otherwise, it is the number of pages. |
status | int | Status bits for the growth value in either megabytes (MB) or kilobytes (K). 0x1 = Default device. |
perf | int | Reserved. |
name | nchar(128) | Logical name of the file. |
filename | nchar(260) | Name of the physical device, including the full path of the file. |
'Brain Trainning > DataBase' 카테고리의 다른 글
[MSSQL] 2000 -> 2005 시스템뷰 매핑 (0) | 2013.08.05 |
---|---|
[MSSQL] Database 서버 전체 복구 (0) | 2013.02.20 |
[MSSQL] 안보고 그냥 스크립팅 ~ (SQL Server Takeover Script) (0) | 2013.01.23 |
[MSSQL] General SQL Server Performance Tuning Tips (펌) (0) | 2013.01.22 |
[MSSQL] How to Track Down Deadlocks Using SQL Server 2005 Profiler (펌) (0) | 2013.01.18 |