Important Update: Cohesity Products Knowledge Base Articles
All Cohesity Knowledge Base Articles are now managed via the Cohesity Support Portal: https://support.cohesity.com/s/searchunify. The Knowledge Base articles available here will not reflect the latest information or may no longer be accessible.
问题
在恢SQL 数据库后，通过SQL 企业管理器查看, 数据库处在"正在还原..." 状态。
原因
NetBackup恢复作业发起之前，Recovery 选项设置为Not Recovery 或其它原因。
解决方案
对于 SQL Server 的一个实例中一个用户数据库可以通过在 SQL 语句清除"正在还原..." 状态.
C:\Documents and Settings\Administrator>osql -E
1> RESTORE DATABASE <Database name> WITH RECOVERY
2> go
通过MSSQL 企业管理器查看时数据库状态已显示正常。
Applies To
SQL 2005 SP2
Was this content helpful?
Translated Content
Please note that this document is a translation from English, and may have been machine-translated. It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information.