Ron_UK


I installed SQL Server 2005 recently on a cluster. I didn't go for the default instance and instead I named the instance option. Now I would like to migrate everything from the named instance to the default instance, which I haven't yet installed.

Is this an easy process What about the logins and the maintenance plans and jobs Is there anything else I need to be aware of




Re: Migrating from named instance to default instance

Madhu K Nair


sadly there is no process available than uninstall and install method.

(a) Install Default Instance

(b) Migrate all the user database using Backup/restore or detach/attach method

(c) Transfer all the login : http://support.microsoft.com/kb/246133

(d) Script all the job from named isntance and run it on default instance

(e) Maintenance plan you can store as file object and transfer

Madhu