Restore SQL 2008 full database backup to SQL Server 2005

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-General, Varinder Sandhu

My friend wants to restore the SQL 2008 full backup to SQL Server 2005. He faced an issue while restore the SQL 2008 full backup to SQL Server 2005. He has a question from me as:

Can we restore the SQL 2008 full database backup to SQL Server 2005?

Answer:

No, we can’t restore a backup from a higher version of SQL Server on a lower version of SQL Server.

Alternative:

If you are not using any features specific to SQL Server 2008, you might be able to generate the scripts and re-create the schema and data in SQL Server 2005. You can use the import/export data wizard to import data.

If anybody has any other solution, please share as a comment.

facebookShare on Facebook
TwitterPost on X
FollowFollow us
PinterestSave
, ,