Database File Path

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  January 5, 2011 at 4:41 pm

  #245022

  Hello Everyone

  I am having a little trouble in recalling from what table the database files are listed for SQL 2008 and for SQL 2005.

  Thanks in advance

  Andrew SQLDBA

• chris.schau

  Mr or Mrs. 500

  Points: 580

  More actions

  January 5, 2011 at 6:31 pm

  #1269832

  Querying sys.database_files should work in either version.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  January 5, 2011 at 9:35 pm

  #1269858

  http://msdn.microsoft.com/en-us/library/ms174397.aspx