I have SQL Server 2012 backup files and want to restore these to SQL Server 2016/2014. Will it work?
I need to find this out before I uninstall SQL Server 2012.
Sql-server – Restore a SQL Server 2012 backup file in SQL Server 2016/2014
backupmigrationrestoresql server 2014sql-server-2012
Related Question
- Sql-server – Sharing keys and certificates between SQL Server 2014 server for encrypted backup and restoration
- SQL Server 2016 – How to Fix Slow Restore Performance
- SQL Server 2014 – How to Fix Database Backup/Restore Issues
- Sql-server – “Cannot find data type” restoring a SQL Server 2014 backup on SQL Server 2008 R2
- Sql-server – Migrating SSRS from SQL Server 2012 to 2016
- Sql-server – SQL Server 2014 Restore DB only has “Verify Backup Media” option
Best Answer
Yes this will work. You can always go forward, you can't go backwards, at least not with backup and restore. With older version eg SQL 2000, SQL 2005 sometimes you have to do a stepped upgrade, ie go from 2000 to 2008 to 2014, but that shouldn't be a problem for you.
Be aware when you restore your databases they will have the older database compatibility level.