September 14, 2009 at 7:21 am
I work as a database administrator and need to install a new SQL Server 2005 instance on a newly installed Windows Server 20003 server named LuckySql. This new instance must have the same settings as the existing SQL Server 2005 instance on a server named UnluckySql. Can the default installation folder be used for the new SLQ Server instance on Unlulckysql? You will be able to refer to Luckysql to view the settings. Simply can we have the same settings as we in the new installation as we have in any other installation of the server?
-LK
September 14, 2009 at 7:26 am
luckysql.kinda (9/14/2009)
I work as a database administrator and need to install a new SQL Server 2005 instance on a newly installed Windows Server 20003 server named LuckySql. This new instance must have the same settings as the existing SQL Server 2005 instance on a server named UnluckySql. Can the default installation folder be used for the new SLQ Server instance on Unlulckysql? You will be able to refer to Luckysql to view the settings. Simply can we have the same settings as we in the new installation as we have in any other installation of the server?-LK
LOL, this sounds like an interview question so much, you might be lucky and get a reply, no pun intended... 😛
Depends on what you mean by same settings, your question doesnt quite read right...
are you talking about a named instance install on unluckysql or a new install on luckysql with the settings from unluckysql.... 😉
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 14, 2009 at 7:31 am
luckysql.kinda (9/14/2009)
I work as a database administrator and need to install a new SQL Server 2005 instance on a newly installed Windows Server 20003 server named LuckySql. This new instance must have the same settings as the existing SQL Server 2005 instance on a server named UnluckySql. Can the default installation folder be used for the new SLQ Server instance on Unlulckysql? You will be able to refer to Luckysql to view the settings. Simply can we have the same settings as we in the new installation as we have in any other installation of the server?-LK
You can refer the Installation document for Unluckysql which should be mentioning the settings.
AFAIK, I don't think you can use the installation folder of one instance to install the other.
September 15, 2009 at 10:08 pm
I don't think you can share the same installation folder amongst multiple instances.
Manu
September 16, 2009 at 6:56 am
Yes I need to use the same installation which I have in my named installation on the same m\c.
-lk
September 16, 2009 at 12:25 pm
We passed through the same requirement several years ago.
We created step-by-step instructions for every "How to..." procedure, so each process is very well documented now.
The brief description of this instruction with a check list is a written standard for us, especially helpful for the new and junior DBAs.
Now it is easy to create mimic.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply