Put backup database on secondary server
Solution: After performing a fresh backup of the original database, Login to the secondary SQL Server Management Studio. Check if a user is logged in via task manager (If the service is in use but no user is logged in, restart the service)
Restarting the service
After performing the steps shown in the above screenshot
--> Select from device
--> From file
--> Add
--> SQL Backup
--> Select a fresh .bak file previously backed up from original server
--> Tick on Restore
--> Options
--> Restore options
--> Tick overwrite
--> Click on OK.
