none
数据库显示正在还原是什么原因? RRS feed

全部回复

  • 你好,

    正在还原的原因是没有恢复(Recovery),导致数据库无法上线。

    你可以执行以下语句:

    Restore database [dbname] with recovery

    希望能解决你的问题,如果还有问题请随时告知我


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2020年1月21日 2:38
  • 正在还原是没有恢复?为什么会没有恢复?是操作不当还是数据库有错误才有这种结果的发生?
    2020年1月21日 5:35
  • 一般情况,这不是一种错误,是一个状态。

    如果是Rostore with norecovery,数据库就会是正在还原的状态。只要在执行Restore database [dbname] with recovery,数据库就恢复了,就能正常上线了

    你可以看这篇文章,讲述了关于数据库的状态,这可以帮助你理解还原(Restore)和恢复(Recovery)的区别:https://docs.microsoft.com/zh-cn/sql/relational-databases/databases/database-states?view=sql-server-ver15


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.



    2020年1月21日 5:48
  • 正在还原是没有恢复?为什么会没有恢复?是操作不当还是数据库有错误才有这种结果的发生?
    Did you find any db restore session on the server? Can check it with sp_who2.
    2020年1月21日 19:04
  • 你好,

    请问您的问题解决了吗?
    如果您使用我们的解决方案解决了该问题,请帮忙‘Mark as Answer'以帮助其他社区成员迅速找到有用的答复。
    如果没有,请回复并告诉我们当前情况,以便提供进一步的帮助。


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2020年1月23日 7:33