John Baird
Coatesville, Pennsylvanie, États-Unis
Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2012
>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement