Upgrade MS SQL Server 2000 to 2008

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

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

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

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.

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

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?

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

Thanks that solved my problem