sys.master_files and sys.database_files difference
-
for one of my critical database , physical name for sys.database_files and sys.master_files doesn't match and is being reported in SQL error log . Can we fix it without taking the database down and any impacts because of this error ? Database restore was performed by DPM recently and I suspect this might have caused this . Suggestions are welcome .
-
You can try ALTER DATABASE File to modify the name.
There is an example at https://msdn.microsoft.com/en-us/library/bb522469.aspx
To modify the logical name of a data file or log file, specify the logical file name to be renamed in the NAME clause, and specify the new logical name for the file in the NEWNAME clause. For example:
MODIFY FILE ( NAME = logical_file_name, NEWNAME = new_logical_name ) - muzikfreakster - Tuesday, August 15, 2017 9:38 PMfor one of my critical database , physical name for sys.database_files and sys.master_files doesn't match and is being reported in SQL error log . Can we fix it without taking the database down and any impacts because of this error ? Database restore was performed by DPM recently and I suspect this might have caused this . Suggestions are welcome .
I can't make out what your problem is with all those squiggles. What database_id is causing the problem, and what queries did you run to get those two result sets? Why is it so important to fix it?
John
-
@tazzman - I don't want to change the logical file name of database so this solution is not correct
@John Mitchell-245523I am running below 2 queries
select * from sys.database_files where name = 'xxx'
select * from sys.master_files where name = 'xxx'
my problem is physical name looks very strange to me , it is not causing an prob as of now only reflecting in the error logs . -
issue has been fixed . there was another test database which was sharing the same file name . I dropped the test database and issue resolved
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply