Copying SQL 2000 databases to a 2008SQL Platform

ahmad1467 used Ask the Experts™
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?

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
Back them up on SQL2000 and restore them on SQL 2008
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