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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Nov 28, 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.

Installation

  • 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.


Download

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.

Any
comments would be greatly appreciated.
Download DBFiles.



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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