Monday, February 7, 2011

How do we know which files and file groups are ONLINE


select fg.name as FilegroupName, fg.type_desc as FileGroupType, df.name as FileName, df.physical_name, df.state_desc 
from sys.database_files df left outer join sys.filegroups fg on df.data_space_id = fg.data_space_id

No comments:

Post a Comment