Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL 2005 vs. SQL 2008
Message
General information
Forum:
Microsoft SQL Server
Category:
Backups
Environment versions
SQL Server:
SQL Server 2005
Application:
Web
Miscellaneous
Thread ID:
01502728
Message ID:
01502776
Views:
40
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform