November 9, 2005 at 1:51 pm
I want to convert an unnamed instance to a named instance and add a second instance. Then pull some of the databases under the original unnamed instance and put them in the second instance. How do I turn the unnamed instance into a named instance? And can I detach the databases from the original instance and attach them to the second named instance?
The unnamed instance is running on SQL Server 2K Enterprize Edition installed on a single Server running WIN2K.
Thanks for any advice,
Jean
November 9, 2005 at 1:54 pm
Instances can only be created upon install. Thus I think you are left with 2 installs to do to accomplish your goal.
A.J.
DBA with an attitude
November 10, 2005 at 3:06 am
I underwent a similar task not long ago. I did a lot of searching to see whether it was possible to "convert" a default instance to a named instance. Unfortunately I didn't find a solution, and so ended up doing multiple installations of named instances, transferring the databases from the default instance, and then removing the default instance.
Even if there is a way of converting a default to a named instance (and I'd be interested to see if anyone knows of a way!), my guess is it's probably more hassle than going through the installation process to create your named instances (plus there's less risk of actually messing things up!).
November 10, 2005 at 6:28 am
You cannot convert a default instance to a named instance. You will need to create a new named instance, as previously mentioned.
Yes, you would detach/attach from the default instance to the named instance.
November 10, 2005 at 7:02 am
We researched this also, including a call to Microsoft. There is no way to change a default instance to a named instance. You must uninstall the default instance (unless you want to leave it for other purposes), and reinstall as a named instance.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply