Can we restore a SQL Server 2008 backup in SQL Server 2005?
NO, we can not restore higher version of databases to a lower version. It is not possible to restore a database from a backup of a newer version to older version as database backups are not backward compatible.
There is a workaround to transfer a database from SQL server 2008 to SQL Server 2005, i.e
- Creating a Script from a existing 2008 database
- Using this Script (Created in Step 1), create database and database objects in SQL Server 2005 / older versions.
- OR Start using Data Transfer tool to copy data from SQL Server 2008 to SQL Server 2005 ot lower versions.
Other Related posts.
I have already posted an article on restore Database in SQL Server 2008 from a backup file, created in older versions and restore higher version of databases to a lower version (2008 to 2005)