Took backup of database from
SQL Server 2008 R2 Enterprise and trying to restore it on a database on
SQL Server 2019 Enterprise but getting error:
Exclusive access could not be obtained because the database is in use
I took destination database offline but no luck. Restarted SQL Server service but no luck.
Close existing connections to destination database is checked under
Options but no luck (screenshot attached). There is enough disk space available.
Is the error coming due to version difference? If yes, then how to restore database from 2008 R2 to 2019?