How can I migrate database from ms SQL Server 2000 to SQL Server 2005? What are the steps?

  • Interview Candidate
  • 3
  • 1583

Showing Answers 1 - 3 of 3 Answers

bugeye

  • Mar 15th, 2008
 

Take a full backup and restore or dettach 2000 db copy .mdf and ldf to 2005 server.  Attach then switch compatiblity mode to 90 then update statistics.  Once you go to 2005 you can go back.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions