asked on

Upgrade MS SQL Server 2000 to 2008

I have a 32 bit MS SQL Server 2000 datase. But now they are going to upgrade the server to version 2008 which is 64 bit. How do I do that?

Rikin Shah

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

Selim Abd El Sattar

hello
check this
http://msdn.microsoft.com/en-us/library/ms144267.aspx

StefanLambda

You can backup databases and restore on the new instance (and check the compatibility issues).

Frans_Truyens

ASKER

I only want to upgrade the database itself. MS SQL Server 2008 R2 will be installed on a fresh installation of MS Windows Server 2008 R2. I have to copy the data only from the old, 2003, server to the new one.

Selim Abd El Sattar

you should backup your DB first and also the master DB , backup your logins if you r using Sql Authentication

ASKER CERTIFIED SOLUTION

Asim Nazir

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Frans_Truyens

ASKER

Hi asimnazir123
I once upgraded from MS SQL Server 2005 to 2008. And the only thing I had to do was re attaching the database to the new SQL Server. Is that the same procedure for 2000 to 2008?

Asim Nazir

Ok. It can work. I am attaching a short guide/knowledge base for your reference. Go through it and it will be helpful for you.

SQL-2000-to-2008-Upgrade-strateg.docx

Asim

SOLUTION

StefanLambda

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Frans_Truyens

ASKER

Thanks that solved my problem