March 16, 2007 at 11:23 am
I need to revert a named instance to a default instance. After looking at the group threads, it appears the best thing to do is delete the named instance and install a new default instance, and restore the user dbs. Is it possible to somehow to save the security accounts and linked server accounts of the named instance before I delete the instance and then import (restore…. whatever) them into the new default instance. Thanks for everyone for being there to help.
R.,
Ed SQL 2000 SP 4
March 18, 2007 at 9:13 pm
Have a look at the output from sp_linkedservers - I think it gives you some but not all of the info you need on linked servers
DTS can transfer logins - you might be able to install your new instance and transfer logins before de-installing the named instance.
As for the user databases, detach/attach is probably the quickest way to move them to the new instance.
Have you thought about SQL Agent jobs, alert, operators and DTS packages ? It is pretty easy to script the jobs.
For the DTS packages, I would backup the current msdb database and then restore it with a different name to the new default instance and then
INSERT INTO MSDB.DBO.SYSDTSPACKAGES SELECT * FROM OLDMSDB.DBO.SYSDTSPACKAGES
March 19, 2007 at 9:25 am
Ed,
There's a script in the script section of this site that will script out all the linked servers in an instance. I used it recently to transfer linked servers from SQL2000 to SQL2005. You can find the script at http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=620
There are several options for transferring logins and users. I've had good luck with the methods described in this article http://support.microsoft.com/kb/246133/en-us. You can't install a default instance if a named instance already exists on a server.
Greg
Greg
March 19, 2007 at 9:32 am
Thanks Greg and Happycat59, for the very helpful info.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply