Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL 2005 vs. SQL 2008
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Versions des environnements
SQL Server:
SQL Server 2005
Application:
Web
Divers
Thread ID:
01502728
Message ID:
01502776
Vues:
41
SQL Server version determines backup format.
To be precise, internal DB version is what SQL Server backup and restore rely on. That version directly corresponds to SQL Server version. You can see how it's upgraded when restoring SQL 2005 to SQL 2008

>OK, then the question is, when I create a backup of a database (using SSMS), what determines the format of the backup? Is it the database engine the database currently resides or is it the version of SSMS that is being used to create the backup? And similarly, what determines the restore format, namely the database engine you are restoring to or the version of SSMS you are using to restore the database?
>
>
>>A DB compatibility level only controls SQL Server engine behavior. What is affected is clearly stated in BOL ALTER DATABASE Compatibility Level topic for the latest SQL Version or sp_dbcmptlevel procedure description otherwise.
>>MS SQL Server supports only forward compatibility of backups for 2 versions. The backward compatibility of backups is not supported at all. IOW, SQL 2008 backups cannot be restored to SQL 2005.
>>If you want to move data in that direction, you have to use some other means.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform