Saturday, May 18, 2024
HomeDatabaseSQL Server - Get Physical Names and Attributes of Database Files

SQL Server – Get Physical Names and Attributes of Database Files

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.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

LATEST REVIEWS

Recent Comments

error: Content is protected !!