If the client has multiple databases, this script helps to find out which database files is the most used. Let us learn today.
SQL SERVER – Most Used Database Files – Script
If the client has multiple databases, this script also helps us to find out which database and particularly which database file is the most used.
Can a Database Have Multiple Files with Extension MDF? – Interview Question of the Week #279
Question: Can a Database Have Multiple Files with Extension MDF?
Answer: Yes. It is possible to have multiple files with extension MDF.