SQL SERVER – 2005 – Get a row per file of a database as stored in the master database | Journey to SQL Authority with Pinal Dave

Each database have minimum of two files associated with database. If database has more than one filegroup it will have many files associated with one database. Following quick script will give you recordset per file of a database which are stored in master database. SELECT name, physical_name, type_desc, state_desc FROM sys.master_files Above script will return… Continue Reading...

Source: SQL SERVER – 2005 – Get a row per file of a database as stored in the master database | Journey to SQL Authority with Pinal Dave