Upgrade to 2005 from 2000? 1

[mk81596]

I upgraded our SQL2000 server instance to 2005. Everything looks like it was moved over. SQL 2000 is still on the system. Can I remove this now or if you use legacy components do you have to keep it.


Thanks,

 

[mrdenny]

If you upgrade the existing instance you shouldn't see much of SQL 2000 left. Are you sure that you upgrading the existing instance?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mk81596]

Yes I upgraded. All the data is in 2005 management studio. Can I remove 2000 now?

 

[mrdenny]

That's the think. There shouln't be much to remove. I'd leave it there so that it doesn't try to remove the SQL 2005 services.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mk81596]

How do I verify that I am using 2005 and not using 2005 tools to just manage 2000?

 

[mrdenny]

Connect to the engine and run

select @@VERSION

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mk81596]

Dennis thanks for all your help...It comes back saying SQL 2000. Should I uninstall 2005 and reinstall and instead of selecting default instance the correct named instance? Or can I backup the databases uninstall 2000 and restore in 2005? Any ideas?

Thanks,

 

[mk81596]

Since I selected default instance on the upgrade it should have upgraded the default instance which is showing up in the management studio now?

 

[mrdenny]

If your SQL instance is a named instance and you told the SQL 2005 installer to install the default instance then no upgrade was performed. You'll need to uninstall the incorrect instance and reinstall it in order to keep the instance name the same.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mk81596]

How can i determine if it is the default or named instance. On the SQL server I am connecting to the server name which means it is the default instance if i were connecting to a named instance it would be servername/name i would be connecting to. Thanks for the help, maybe i am getting default and named instances mixed up.

 

[mrdenny]

Correct the default instance would be connected to as "COMPUTERNAME" while a named instance will be "COMPUTERNAME\INSTANCENAME".

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mk81596]

Thanks a ton for the clarification...One more question. So origninally the 2000 database was already the default instance. When I upgrade wont I want to select default instance then?? That is what I did and it did not upgrade anything.

 

[mrdenny]

Yes you will want to select the default instanct. Sounds like the installer didn't take the upgrade and it only installed the client tools.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mk81596]

You recommend uninstall and reinstall of 2005 then?

 

[mrdenny]

You shouldn't need to uninstall. Just run the installer again.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mk81596]

re-ran the install and installed in same location that 2000 was installed and everything upgraded correctly

 

[mrdenny]

Excellent.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com