Is it possible to take a SQL 2017 database backup and restore to SQL 2012 if I first restore the SQL 2017 backup file to a SQL 2016 server first. Once restored on the SQL 2016 server, can I perform a backup of SQL 2016 and restore the database on SQL 2012 server? I realize that I can't perform a backup/restore from SQL 2017 to SQL 2012 because it is more than 2 versions old, but by using SQL 2016 as a go between, can this work?
I realize that this may seem odd to go backwards, but it would only be used in a Disaster Relief situation if a new rollout fails which would force us to go back to the original application that is currently running in SQL 2012.
Any insight around this is very helpful.
Thanks,
Doug