CREATE VIEW sys.sysaltfiles AS
	SELECT fileid = convert(smallint, f.file_id & 0x7fff),
		groupid = convert(smallint, f.data_space_id),
		f.size, maxsize = f.max_size, f.growth,
		status = convert(int,
					case f.type when 1 then 66 else 2 end   -- x_eft_SQLLog, FCB_LOG_DEVICE, FCB_DSK_DEVICE
					+ f.is_media_read_only * 16 -- FCB_READONLY_MEDIA
					+ f.is_read_only * 4096 -- FCB_READONLY
					+ case when f.file_state in (1, 2, 3, 6) then 268435456 else 0 end -- OFFLINE, FCB_OFFLINE
					+ f.is_sparse * 536870912 -- FCB_SPARSE_FILE
					+ f.is_percent_growth * 1048576), -- FCB_PERCENT_GROWTH
		perf = convert(int, 0),
		dbid = convert(smallint, f.database_id),
		f.name, filename = f.physical_name
	FROM sys.master_files$ f
	WHERE f.recovery_unit_id = 0 AND f.type IN (0, 1) -- x_eft_SQLData, x_eft_SQLLog (bwkcmpt types)