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.
MerionAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
lcohanConnect With a Mentor Database AnalystCommented:
You need to do a SQL server service re-start for the change to take place but it may be tricky in cluster environment. If your db is attached to a SQL server not a SQL cluster then restart should do it.
0
 
MerionAuthor Commented:
That was it. Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.