Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Install MSSQL 2012 - 32 bit or 64 bit?
Message
De
01/11/2013 14:10:13
John Baird
Coatesville, Pennsylvanie, États-Unis
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2012
Application:
Web
Divers
Thread ID:
01587104
Message ID:
01587123
Vues:
49
>>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!!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform