Restore backup db made in SQL server 2000 to 2014

Question

User-1352156089 posted

Hi All,

is there a way to restore a db backup in SQL server 2014 which was made in SQL server 2000?

Thanks

Answer 1

User753101303 posted

Hi,

What happens when you try? Not 100% sure but from http://msdn.microsoft.com/en-us/library/bb510680.aspx my understanding is that you can't (ie SQL Server 2014 can restore SQL Server 2008 or later databases ?). So you'll likely have to use SQL Server 2008 or SQL Server 2008 R2 Express Edition to do an intermediate restore/backup (and likely the compat level needs to be changed between the restore and the backup).

As this is quite specialized a SQL Server forum at the http://msdn.microsoft.com site might be better for this particular question.

Answer 2

User77042963 posted

You need to restore to one or two versions in between. (SQL Server 2000,2005,2008,2008R2,2012,2014)

Try to restore it to SQL Server 2008 R2 and backup from there and use the new backup from 2008 R2 to restore in 2014.