I have the scenario where I have to generate a backup of the database (SQL Server 2008) and restore into the new server (SQL Server 2016). While taking backup data should not be changed in any case. So I have two options to do that, but I am not sure how it will work. (Everything is using SQL Job only.)
Set a read-only database and restore into the new DB server.
→ Is it possible to restore a read-only DB on the new server? The destination server is already having a read-write (online) database by the same name.
Set an offline database and restore onto the new DB server.
→ Is it possible to restore an offline DB in the new server? The destination server already has an online (read-write) database by the same name.