New answers tagged sql-server-2008-r2
First off, as TomTom already stated, yes it is possible. Using a backup / restore procedure is the proper way to upgrade your database. However, you will still need to do some other actions. You will need to migrate the SQL server logins to the new instance. You will need to test if your app doesn't use features that were removed. Most notably here is the ...
Assuming I don't want any new features of 2012 is it as easy as restoring the 2008 databases on the new server? It is - plus setting trace flags for the server to force the old behavior of the query optimizer, I think. If that works, I guess it's not the recommended way, Why not? It totally looks like the recommended way to me.
From looking at https://support.microsoft.com/en-us/kb/2919355 the only included update that mentions sql is https://support.microsoft.com/en-us/kb/2920006. You might look and see if it has anything to do with your issue.
Since your plan is to shut down the system during the time it takes to send the last incremental backup, then your plan is good. Just make sure to use the NORECOVERY option when you apply all of the backups except for the last incremental.
Top 50 recent answers are included