Install sqlserver2008 on old server

Question

Install sqlserver2008 on old server

ashkan sirous

SSCrazy

Points: 2733
More actions
December 25, 2010 at 12:31 am

#231019

Hi friends,
I have an old Server , with Intel Xeon(TM) 3GH CPU and 4GB Ram and Windows server 2003 32bit.
I have a SQLServer 2000 with some Databases on It.
I Want to install An instance of SqlServer2008 on this server, So I can transfer My DB's Slowly.
I want to know:
1- Is there any problem whit this method?
2- Is there any conflict with sqlserver 2000 and 2008?
3 -Do you think My server will be slower?
Best Regards
A.Siroos
Best Regards,
Ashkan

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Dugi SSCoach Points: 17998 More actions · Answer 1

According to your server details (little details), I can say YES you can install the SQL Server 2008! Before to install you can use the upgrade adviser with SQL Server setup!

I think that you will do some migration process, but before that you should read about upgrade process from SQL Server 2000 to 2008:

Take a look to this: http://www.sqlservercentral.com/articles/Upgrade/65872/[/url]

Also you can check the upgrade details from SQL Server 2000 to SQL Server 2008 R2.

http://msdn.microsoft.com/en-us/library/bb677622.aspx

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

ashkan sirous SSCrazy Points: 2733 More actions · Answer 2

Thanks dugi,

It was really helpful.

Best Regards,
Ashkan

ashkan sirous SSCrazy Points: 2733 More actions · Answer 3

Ok, Now I have installed and run Upgrade Adviser.

There will be some errors, Most Of them on MS DB!:D

It is strange! why Microsoft Cant upgrade his product without any problem?

I don't think this problems will be serious.

Any Idea?

Best Regards,
Ashkan

Nakul Vachhrajani SSChampion Points: 10283 More actions · Answer 4

ashkan siroos (12/27/2010)
Ok, Now I have installed and run Upgrade Adviser.
There will be some errors, Most Of them on MS DB!:D
It is strange! why Microsoft Cant upgrade his product without any problem?
I don't think this problems will be serious.
Any Idea?

Ashkan, please don't blame Microsoft without understanding why the Upgrade advisor is telling you about possible errors on the MSDB.

There have been major architectural changes in SQL Server 2005 when compared with SQL Server 2000. It's almost as if a single storey building now has a basement car park and 3 stories above the ground. When such major changes are done, it is obvious that there will be a lot of damage and re-engineering required to the old, pre-existing entities.

Similar is the case with SQL 2000 and SQL 2008. I would say Microsoft has actually done a great job by saving the effort of a failed upgrade. Just imagine what would happen without the upgrade advisor?

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com

Follow me on
Twitter: @sqltwins

ashkan sirous SSCrazy Points: 2733 More actions · Answer 5

Yes, Upgrade adviser is a good tool when Somebody wants to upgrade one server.

OK , I will upgrade my server this Friday.

I want to know what will happen next?

I will Do all Suggested tasks before Upgrade SQLServer , Then what?

And also, What will happen to my databases?

Do I need to upgrade their compatibility to 2008 or Upgrade will change the compatibility of them?

Any good articles do you have?

Best Regards,
Ashkan