0

By reading the various versions of BOL article Restore a Database Backup (SQL Server Management Studio), I have determined that all versions of SQL Server from 2005 to 2014 can restore a 2005 backup. This can be deduced by reading the corresponding version of this sentence:

Note that if you restore a SQL Server 2005 or higher database to SQL Server 2014 ...

Is there a reference that lists this information explicitly? That is, given a version of SQL Server, I would like to see at a glance which earlier versions' backups can be restored.

Test User
  • 37
  • 1
  • 9

1 Answers1

0

Basically you can restore any backup from an older version of SQL server to a newer version. That means you can restore:

  1. 2005 to 2008, 2008R2, 2012 and 2014
  2. 2008 backup can be restored to 2008R2, 2012 and 2014
  3. 2008R2 to 2012 and 2014
  4. 2012 to 2014

If you need the official documentation you can check the link you presented in your question http://msdn.microsoft.com/en-us/library/ms177429(v=sql.120).aspx and just change the version (it's under the title).

Andrei Hirsu
  • 686
  • 4
  • 11
  • You can _usually_ but not necessarily restore a previous version. I am fairly sure that you can't restore from 6.5 to 2000. [This Technet article](http://blogs.technet.com/b/mdegre/archive/2012/06/15/migration-sql-server-2000-to-sql-server-2012.aspx) says that you can't restore from 2000 to 2012. With respect to your suggestion about official documentation: that is _exactly_ what I did and I said so. – Test User Nov 12 '14 at 00:00
  • The answer to this[Stack Overflow question](http://stackoverflow.com/questions/23446651/how-to-restore-a-old-backup-from-sql-server-7-sp4-to-newest-sql-server-versions?rq=1) mentions a 3-version rule with the exception that 2014 can restore 2005 SP4.It would be good if I could find a reference that says that this is official Microsoft policy. – Test User Nov 12 '14 at 02:18