Restore SQL database to newer version I'm using Drupal 7 on Windows and its using SQL Server 2008 RS2 (SP2).
Now, I have to move my site and new server using SQL Server 2016.

How can I restore my database to new server? Is it possible?

Thanks.
Simply backup the database on 2008R2, then restore it on the new server. You can change the compatibly level to the new version. The last thing to do is to add the logins from the old server, you can check out this link: Restore database rights on restored database SQL 2012