SELECT'DB_NAME' = db.name,'FILE_NAME' = mf.name,'FILE_TYPE' = mf.type_desc,'FILE_PATH' = mf.physical_nameFROMsys.databases dbINNER JOIN sys.master_files mfON db.database_id = mf.database_idWHEREdb.state = 6 -- OFFLINE