Link to home
Start Free TrialLog in
Avatar of Merion
MerionFlag for United States of America

asked on

logical file name is different in sys.database_files vs sys.master_files

The logical name of a database file went out sync after running following statement.

ALTER DATABASE UserDataBase MODIFY FILE (NAME = 'FileNameOld', NEWNAME = 'FileNameNew')

It updated the name column of sys.master_files table correctly to "FileNameNew" but the name column of sys.Database_files table remained as "FileNameOld".

Does anyone know the cause of it and how to fix the problem? Thanks in advance.
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Merion

ASKER

That was it. Thank you.