March 27, 2003 at 3:09 pm
When you create a database through a restore of another databases backup on the same server you can change the physical file name by using the with move option however, you are unable to change the logical file name. Old territory I know.....
Question is this. Has anyone come across any problems associated with having multiple databases on the same server with the same logical filename?
I have never used the scenario before because I don't like the IDEA of duplicated logical filenames on the same server but I was wondering if there was any true problem with it.
Thoughts, experiences?? Thanks in advance.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 27, 2003 at 6:14 pm
I have few databases with same logical name after the restoration and never experience any problems. If you really don't like that, you always can change the logical name with ALTER Database command after database be restored in SQL Server 2000.
You can't change the logical name is 7.0.
Edited by - Allen_Cui on 03/27/2003 6:16:24 PM
March 28, 2003 at 2:12 am
Never used it myself, but I can't see how it would be a problem, since logical file names are local to database.
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 28, 2003 at 6:34 am
Thanks Gentlemen. Allen_Cui - Yup, I'm in 7.0 land - but not for long.
If anyone does come up with any issues associated with this I would be interested to hear.
Thanks again.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply