Can we Restore database backups in SQL Server 2005/2008/2008 R2 which were backed up in SQL Server Denali ?

Posted by Mahesh Gupta on December 9, 2010 Leave a comment (0) Go to comments

Can we Restore database backups in SQL Server 2005/2008/2008 R2 which were backed up in SQL Server Denali ?
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 because SQL Server 2011 (Denali) database backups are not backward compatible with SQL Server 2008/2005.

If you try to do so, you will end up getting the following error message.

Can we Restore database backups in SQL Server 2005/2008/2008 R2 which were backed up in SQL Server Denali ? Restore database backups DEnali restore a backup of a SQL Server 2011 database onto an instance of SQL Server 2008 / 2005

How to restore Database in SQL Server Denali from a backup file, which was created in older version?

All Blog Posts, Popular, SQL 2012, ,
EOF - Can we Restore database backups in SQL Server 2005/2008/2008 R2 which were backed up in SQL Server Denali ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *

*

CAPTCHA Image

*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.