Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is it possible to restore Sql Server 2008 backup in sql server 2005

Is it possible to restore a backup of a SQL Server 2008 database onto an instance of SQL Server 2005?

I need to work on an sample application for which database backup is in sql server 2008. But I'll not be able to install 2008. So is it possible to restore that back up in 2005?

like image 612
Nayana Setty Avatar asked Feb 13 '09 09:02

Nayana Setty


People also ask

Can I restore a SQL 2008 backup to SQL 2019?

A backup taken on SQL Server 2008 and later, can be restored to SQL Server 2019 (15. x) without changing its compatibility level, as long as the database backup has a compatibility level of 100 or higher.

Can we restore SQL Server 2008 backup to 2016?

Yes you can directly migrate to SQl 2016 either attach/deattach or backup and restore.

Can we restore SQL Server 2008 backup to 2014?

Yes. you only must restore your backup. I Upgrade all on my database on my company from SQL Server 2008R2 and SQL Server2012 to SQL Server 2014 with backup and restore (about 45 database).

Can we restore SQL Server 2008 backup to 2017?

Yes, SQL Server is backward compatible. You can restore a database from any previous version of SQL Server that was supported at the time of the release. For SQL Server 2017, you can therefore restore databases from SQL Server 2008 to 2017. SQL Server, however, is not forward compatible.


1 Answers

No. It is not possible to restore a database from a backup of a newer version.

If you are dead set on it, I think your best option is to selet the database in the Object Explorer in SQL 2008, right-click, select Tasks->Generate Scripts.In the options dialog emable about everything, including Script Data.

And make sure you select "Script for SQL 2005".

Source

When importing the objects into your target server, if the objects are large you may find that you can't open the SQL file via Management Studio (with a completely useless "The operation could not be completed" error, no less). That's okay, just load the file via sqlcmd.

like image 122
Garry Shutler Avatar answered Oct 01 '22 09:10

Garry Shutler