Script to obtain database name and associated files

• dave109

  SSC Enthusiast

  Points: 131

  More actions

  March 10, 2005 at 12:19 pm

  #76256

  I'm an looking for a script that will give me the database name and associated files (data and log) for that db.  For example, the result of the script will show:

  DBName         DataFile        LogFile

  TEST             TEST.MDF      TEST.LDF

   

  Thank you.

• Jim P.

  SSCrazy Eights

  Points: 8725

  More actions

  March 10, 2005 at 12:26 pm

  #546464

  Take a look at this script SQL Server Database File Sizes.

  It also will give you file sizes and both physical and logical data file names.

  
  
  ----------------
  Jim P.

  A little bit of this and a little byte of that can cause bloatware.

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  March 11, 2005 at 12:35 am

  #546546

  Profiler - is your best friend!!!

  Start profiler and open properties for the DB. Profiler will show you the query EM used to retrieve this information.

  Remember: you've paid for this functionality when you purchased SQL Server. So use it!

  _____________
  Code for TallyGenerator