You can get the file location, size, maxsize, growth and usage attributes of a database without leaving your Enterprise Manager or Management Studio. To do this:
1. Open the query window.
2. Select the database that you will be requesting information on.
3. Type exec sp_helpfile.
4. Execute the query.
The results set will include the database name, fileid, filename, filegroup, size, maxsize, growth and usage for both the data file and the log file.
