March 31, 2015 at 6:50 am
I have just come across something a bit weird, and I cant find anything similar whilst googling.
For one of my databases on a SQL 2005 instance, when I look at sys.database_files, the physical_name appears to contain an extra slash:
J:\SQLData\\DatabaseName\File05.ndf
This made me curious, so I looked at the files tab under database properties, where it actually displays what id originally expected to see:
J:\SQLData\DatabaseName\File05.ndf
...without the double slashes.
After profiling what actually happens when I open the properties, it looks like the properties window is also looking at database_files.
Therefore, im lost as to firstly, why the double slash exists in database_files and secondly, why it appears differently when accessed by the GUI!
The database is up and running without any issues, and there are no special characters to escape in the file name.
Has anybody ever seen this? Any ideas on how to rectify, or even if it does need to be changed?
Many thanks
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply