If you mean moving the DB to another server with SQL2005 it’s one thing; if instead you need to upgrade the existing SQL2000 it’s a “next, next, continue” process.
please be more specific.
This is Md.Aves You need to take backup of ur database from SQL 2000 for that you have to write this query in query analyzer — for exmple ur database name is student
backup database student to disk =’D:\student.bak’ for taking backup.
and for restoring that backup copy in SQL 2005 you have to write this query–
restore database student from disk =”D\student.bak’
the sttudent database will be migrated from SQL 2000 to SQL 2005.