SQL: List of database files

The script below 1
can be used to extract a list of databases along with the files associated with each database. The size (according to SQL Server) is also returned in pages and bytes.

  1. Please ensure you test any script taken from my website on a test/development machine, before running on a production server.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

CJayMead's SQL Server, Endeca, MS Office Help © 2018