Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can I move a SQL 2000 32-bit database to a SQL 2005 64-bit database server

share|improve this question

Yes you can. There are two easy ways to do this:

  1. Create a backup of the database and restore it on the new server.
  2. Detach the database and then move the .mdf and .ldf to the new server and attach them to to it.

I prefer to use the backup method since as the name implies, you're working with a backup of the data so it's relatively low risk.

share|improve this answer

You should also test that your Applications that use those Databases work once you move it over (Backup method is best way to go).

If any of the applications fail you may need to look into using compatibility mode which you can set in the Database Properties, I would suggest making a list of all applications and then doing test first to be sure that nothing plays up.

share|improve this answer
Good point. The databases will move over without a problem but it may cause unexpected issues with any programs that only work with 32-bit software. Always a good idea to test for any potential problems before committing to the change. – Sean Howat Mar 18 '10 at 13:27

32 bit to 64bit should not matter.

The procedure is actually fairly straight forward.

Here is a tutorial that explains it step by step

Take care and good luck


share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.