I have copied a database vn_Budget_2021_BofDOct29 to the database vn_Budget_2021_Rig2. I did this through Tasks->Restore Database shown in the second image.
I saw this similar issue except the database I’ve restored isn’t the one hanging. Its my source DB that doesn’t require any restoring in iteslf.
SQL server databases stuck in restoring state
How do I get it stop hanging? I don’t need to restore this database to the same name. The last backup is a few days old and theres nothing wrong with the data.
Method of restoring. No logs were taken which may be the issue?