Discrepancy between sys.master_files and sys.database_files

• SQL Guy 1

  SSCoach

  Points: 15817

  More actions

  April 1, 2013 at 12:19 pm

  #272974

  Hi all,

  I have discrepancy beetween sys.master_files and sys.database_files in size column. Couple of days ago I changed the size of a log file for one database, however it's not reflected in sys.master_files. Views sys.database_files and sys.sysfiles are OK, they show right value.

  Is sys.master_files outdated? Should I run some DBCC to update it ?

  Thanks