Attaching 64 bit databases to 32 bit.

  • Question

    I have a SQL 2000 database running on the 64 bit version. If I detach the data files and attach them to a SQL2000 server running the 32 bit version will I encounter any problems?

  • I believe that you shouldn't have any problem attaching the 64-bit database to a 32-bit server.

     

     

    Petros

  • Thanks.

    I have confirmed this with another SQL resource on site as well.

  • You can also take a backup of a database ona  64 bit server and restore it onto a 32 bit machine.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply