1、
https://social.microsoft.com/Forums/cs-CZ/f0789481-4f28-4c7f-9758-51f983ce4ff4/25968254542421126174310342749122312368242140726159201602004021?forum=sqlserverzhchs
restore database aaa with recovery
执行语句：
Restore database [dbname] with recovery
2、
https://www.cnblogs.com/nuomibaibai/p/16449965.html
解决办法：
执行查询
Restore Database XXX with Recovery
其中XXX是数据库名
执行完语句后刷新下就好了
出现无法还原异常，试试
先执行
Restore Database XXX with Recovery
Restore Database XXX with NoRecovery
再还原一下数据库备份