Phil Johnson
SSC Enthusiast
Points: 148
More actions
February 7, 2006 at 4:40 am
#152737
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?
psa
Old Hand
Points: 336
February 7, 2006 at 5:00 am
#619210
I believe that you shouldn't have any problem attaching the 64-bit database to a 32-bit server.
Petros
February 7, 2006 at 5:47 am
#619216
Thanks.
I have confirmed this with another SQL resource on site as well.
Jason Hall
Hall of Fame
Points: 3906
February 7, 2006 at 7:47 am
#619276
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