I know that this was not possible as a scenario for SQL Server 2012 -> 2008 but I wonder if MS made any changes here with the 2014 version.
We have SQL Server 2014 version with a fairly large database, We’d like to restore a backup of that database to SQL Server 2008 R2 because that physical machine has more space, RAM,…
I’m getting standard error message when I try to restore backup but I was wondering if there is something else in SQL Server 2014 that I might be missing.
Also, are there any tools like Redgate/SQLSentry that will be of any use while working with databases size of hundreds of GB size?
