dbTalk Databases Forums  

Upgrading 2000 Default instance to 2005 does what?

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss Upgrading 2000 Default instance to 2005 does what? in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Earl
 
Posts: n/a

Default Upgrading 2000 Default instance to 2005 does what? - 12-16-2005 , 12:24 AM






I've been running SQL2k Developer on a box with one server as default
instance. I now installed SQL2005 as default instance... realizing only
later that I was "upgrading" the existing default instance.

However when I look at EM for 2000, the database "appears" identical to its
previous incarnation, i.e., databases, tables and sproces appear without
change. Yet when I open the management console in 2005, I also can view
this instance. I've not created any new objects in the database.

So, I'm not curious what the 2005 "upgrade" did to the existing instance and
the databases within and whether I will be able to continue using these as I
did with EM2000, or if some action starts making irreversible changes. I'm
running merge replication on several of those databases and the pubs within
also appear untouched.



Reply With Quote
  #2  
Old   
Rogas69
 
Posts: n/a

Default Re: Upgrading 2000 Default instance to 2005 does what? - 12-16-2005 , 04:11 AM






I noticed that such upgrading does not upgrade the dbms and databases - if
you open the instance from sql management studio you can see its version -
for sql 2000 is 8.0, for sql 2005 is 9.0. I had to uninstall sql 2000 and
afair reinstall 2005 to make it running as 2005.
but there is probably way to stop the 2000 rdbms and using surface area
configuration utility run the default instance of 2005. it seems that if
there is instance naming clash, sql 2005 preserves old database engine.
peter



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.