Restore Database clarifications I have a 1 TB database. I started restoring the database(full backup) with No recovery and replace .In between there is a windows msi installer which installed .net framework 4.6.1 needed a reboot of machine and server got rebooted. After reboot now the database is in restoring mode. But I feel restore is definitely not successful. So now my plan is :

Restore Database DBNAME with Recovery


does not work in this case.


Take the database offline.
Delete the database and re start the restore of full backup again with no recovery and replace.


Please advice if this approach is correct.Or what I am thinking is wrong.
Since database server was rebooted while restore process was still going on so the restore process did not completed successfully.Restoring database with recovery is not going to work it will flash an error. What you have to do is


Open new query window, connect to master database and drop the database which is in restoring state by drop database db_name;
Now start the restore process again.


You should have waited to restart the machine after it prompted for reboot. I am sure it would have prompted but you would have selected for reboot then only it went ahead and rebooted. Avoid rebooting SQL servers when restore process is going on this would disrupt restore process and you would have to start all over again, which is waste of time.