January 7, 2005 at 6:52 am
We have three databases that have identical file names (as reported in the Database->Properties window, under the 'Data Files' tab), although their physical files are named differently. Does anyone know if there are potential issues with duplicate File Name attributes?
Thanks!
January 7, 2005 at 9:06 am
The file_name under data files tab is the logical file name. This should be fine. The location gives the physical file name.
January 7, 2005 at 12:19 pm
I did not have issues yet when creating and using the databases for development by restoring backups of production database on the same developmet server several times under different names. The Database names are different, physical file names are different but the logical file names are the same. Logical file names exist in Sysfiles that is a separate table instance in each database.
The only thing one should remember is the user error when the script that uses a logical name will be used on the wrong database. Well, you may argue that in the case when the logical file names are the same there probably many more things are the same, not only the file names, because it is probably versions of the same original database and anyone can run any script on the wrong database by mistake.
Yelena.
Regards,Yelena Varsha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply