Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

sysfiles System Table - SQL Server 2000

RSS
Modified on Fri, May 01, 2009, 10:55 AM by Administrator Categorized as SQL Server System Tables
Contains one row for each file in a database. This system table is a virtual table; it cannot be updated or modified directly.

Column nameData typeDescription
fileidsmallintFile identification number unique for each database.
groupidsmallintFilegroup identification number.
sizeintSize of the file (in 8-KB pages).
maxsizeintMaximum file size (in 8-KB pages). A value of 0 indicates no |-
growthintGrowth 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 growth is the percentage of file size; otherwise, it is the number of pages.
statusintStatus bits for the growth value in either megabytes (MB) or kilobytes (K): 0x1 = Default device; 0x2 = Disk file; 0x40 = Log device; 0x80 = File has been written to since last backup; 0x4000 = Device created implicitly by the CREATE DATABASE statement; 0x8000 = Device created during database creation; 0x100000 = Growth is in percentage, not pages.
perfintReserved.
namenchar(128)Logical name of the file.
filenamenchar(260)Name of the physical device, including the full path of the file.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.