Copying SQL 2000 databases to a 2008SQL Platform

ahmad1467
ahmad1467 used Ask the Experts™
on
I am currently running Windows 2003 server Standard with SQL 2000 on my server I have some databases that I would like to copy to a Windows 2008 Server with SQL 2008, what would be the easiest way to do this?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior DBA
Most Valuable Expert 2018
Top Expert 2014
Commented:
Back them up on SQL2000 and restore them on SQL 2008
OR
You can save some I/O by detaching them from SQL 2000, copying the files, and attaching them on SQL 2008.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial