-2

Im trying to restore my database on my server, but i got the following error:

The database was backed up on a server running version 12.00.2269. That version is incompatible with this server, which is running version 11.00.2100. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

So I need to downgrade my backup file, but how can I do it? Do I need to install a new instance of SQL Server 2014? With the option "Tasks -> Backup" there is no option to select the version for the backup.

Thanks!

datagod
  • 7,141
  • 4
  • 38
  • 58
Joao Guimaraes
  • 17
  • 1
  • 1
  • 3

1 Answers1

1

As per the message you got you were trying to restore backup taken from SQL Server 2014 database on SQL Server 2012 which of course is not allowed.

So I need to downgrade my backup file, but how can I do it?

You cannot downgrade a backup file, neither can you downgrade, inplace, the database from SQL Server 2014 to SQL Server 2012. You only have option to move database objects and data from SQL Server 2014 to 2012. You can refer to answers given on This and This SE thread to know how to move data and objects. The links are not specific to your version of database but methods would be the same.

Do I need to install a new instance of SQL Server 2012

No it would not be new version of 2012 but new version of SQL Server 2014. If you don't want to follow above method then yes you would have to install new SQL Server 2014 server and then you can restore database on it. But I would suggest you follow advise given above. Installing 2012 would require new license.

Community
  • 1
Shanky
  • 19,148
  • 4
  • 37
  • 58