Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Nov 29, 1999

File Information

By Darren Green, John Percival

As part of the system documentation I maintain about my main SQL Server I wanted to a report detailing the locations of all the database files. It also includes all of the options you can set when creating the DB, including log files. I also use it to help monitor growth over time.

This is an Excel Workbook (97) designed to provide a formatted report, detailing information about all of the database files on your server. It uses ADO to query system tables, and simple macros format the results into a report. A new Worksheet is produced each time the main macro is run, which is kept within the Workbook for future reference.

Unfortunately there was two small bugs in the first version posted here, the template sheet was protected and the Server cell reference in the VBA code was incorrect. These have now been fixed.


  • 1. Download DBFiles.zip (See below)
  • 2. Open the Excel file (DBFiles.xls) contained within
  • 3. On the Overview sheet, set your server name as indicated.
  • 4. Hit Ctrl+Shift+F and watch the report appear

Please note that this is designed for SQL Server 7, and uses integrated security by default. You can easily edit the macro to use SQL Server Logins if you wish.


Please note that this program is provided without any warranty or assurances of any kind. Use it at your own risk. Commercial distribution or distribution for profit in any form is strictly forbidden without prior permission from the author.

comments would be greatly appreciated.
Download DBFiles.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM