November 12, 2008 at 9:10 am
Hi everyone,
currently I need to install a SQL-2005 server on an existing SQL-2000 server server.
If you have done this before, would you kindly give me some notices how to do this correctly and effictively.
I'm looking forward to receiving your reply.
Thnx.
November 18, 2008 at 8:38 am
Certainly this can be done and it not that hard. There ar e the obligitory pre-reqs and you should read MS articles on the subject:
http://msdn.microsoft.com/en-us/library/ms143719.aspx
One of the main things to keep in mind is memory and disk space.
Also keep in mind that if you current 2000 installation is a default instance you will have to go for a named instance (you cant have two the same).
Is this to be a completely fresh SQL s erver or are you going to migrate data and databases to it. Iif so keep in mind that although SQL 2005 is backward compatible in most areas, it isnt so good with DTS and certainly needs the DTS legacy tools to even read.
Anyway, see how you go and write back with any questions or issues.
:exclamationmark: Remember to install SP2 when you have installed and b4 you use :exclamationmark:
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 21, 2008 at 12:17 am
Hi .. we are also going to add a sql 2005 instance on a server with sql 2000 named instance (B).
So im gonna share my pitfalls if any .. thanks for the msdn link...
Adam: You wrote "Remember to install SP2 when you have installed and b4 you use" Does this mean that no services should be started at end of setup until i've added SP2? Correct?
November 21, 2008 at 3:01 am
tomas.mortensen (11/21/2008)
Hi .. we are also going to add a sql 2005 instance on a server with sql 2000 named instance (B).So im gonna share my pitfalls if any .. thanks for the msdn link...
Adam: You wrote "Remember to install SP2 when you have installed and b4 you use" Does this mean that no services should be started at end of setup until i've added SP2? Correct?
I am not saying that you shouldnt, it works fine BUT if you start using it in anger (maint plans, heavy transaction usage etc) you may get some undesired results. So best thing is to just have SP2 as part of your install check list.
Have fun 🙂
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 21, 2008 at 3:12 am
If you have time and willing to learn in-depth then you can download this 7 Mb Article which will give you complete picture for your question....
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
November 21, 2008 at 3:48 am
Sakthivel Chidambaram (11/21/2008)
If you have time and willing to learn in-depth then you can download this 7 Mb Article which will give you complete picture for your question....
Very good link and more helpful.
One more: Planning to upgrade to SQL 2008 see the below links:
http://technet.microsoft.com/en-us/sqlserver/bb331808.aspx
Above links help to migrate SQL Server from lower version to higher versions.
November 21, 2008 at 5:06 am
tuthuan (11/12/2008)
Hi everyone,currently I need to install a SQL-2005 server on an existing SQL-2000 server server.
If you have done this before, would you kindly give me some notices how to do this correctly and effictively.
I'm looking forward to receiving your reply.
Thnx.
This is not a big deal. but try to have different instances for both the sql servers
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
November 21, 2008 at 5:12 am
Just wanted to say that the installation of a 2005 instance on a server with sql 2000 was pretty undramatic. Works great so far... Thanks for all posts on the matter.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply