Retrieve file list of an SQL server database which is offline

user_110963 0
Viewed 38850

I have some offline databases on a SQL server. I would like to know which files on disc are related to these databases. Is it possible to retrieve the file list of offline databases without taking them online first?

tsql sql-server
3 Answers

Or simply

select * from sys.databases where state_desc='OFFLINE'
user_236160
Related