Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Install MSSQL 2012 - 32 bit or 64 bit?
Message
From
01/11/2013 14:10:13
John Baird
Coatesville, Pennsylvania, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2012
Application:
Web
Miscellaneous
Thread ID:
01587104
Message ID:
01587123
Views:
51
>>To the best of my awareness, there shouldn't be an issue with backups - only exception might be if you use a data type or some other entity that's specific to a newer version of SQL, and then try to restore to an older version. But aside from that, I have no knowledge of any issues on backup/restore between 32 and 64 bit for the same general version of the product.
>>
>>Now...there's one other issue with 64 bit. Again, if you have plenty of memory, then 64 bit is the way to go. However, (and not to complicate things), there might be times where you have to disable 64-bit support and use 32-bit for very specific tasks. For instance, a few features in SSIS only work in 32 bit. The total # of instances where this occurs isn't high, but there can be times where you might need a 32-bit driver for something or might need to set a few extra options.
>
>You can not restore backup from the higher version of SQL Server to the SQL Server version of the lower version. E.g., for example, you will not be able to restore SQL Server 2012 backup on the SQL Server 2008 R2. It doesn't matter if you used or not the newest features, the backups are only 1 way compatible.

Duh!!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform