Timeline for How do you identify database .mdf and .ldf file names?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 4, 2017 at 9:38 | comment | added | Zach Smith | Thanks. This is a useful tool if you want to look at a single database. But I found the db name => file name correlation mostly not what I was expecting so had to look at all the DBs holistically | |
| Jan 4, 2017 at 6:13 | comment | added | SQL_Deadwood | Actually, this is a per-database view so it must be run under the proper database context. | |
| Jan 4, 2017 at 6:09 | comment | added | Md Haidar Ali Khan | sys.database_files only showing master file (mdf & ldf). Not user database(mdf & ldf). | |
| Jan 4, 2017 at 6:03 | history | answered | SQL_Deadwood | CC BY-SA 3.0 |