错误:无法打开数据库X，它在还原过程中. [英] error : database X cannot be opened.It is in the middle of a restore.

问题描述

您好，我已经通过sql查询用新名称恢复了数据库.但是现在，当我想使用它时，我收到了以下错误消息:数据库X无法打开.它在恢复过程中."
此错误是什么意思?
我的代码:"restore database [mydb] from disk=N''my backup file path'' with file=1,move N''maindb_Data'' to N''newdb data file path'',move N''maindb_Log'' to N''newdb log file path'',replace,stats=10,norecovery,nounload"

Hi, I have restore my db with new name by sql query.but now when i want to use it i recieve this error : "database X cannot be opened.It is in the middle of a restore."
what is this error meaning?
my code : "restore database [mydb] from disk=N''my backup file path'' with file=1,move N''maindb_Data'' to N''newdb data file path'',move N''maindb_Log'' to N''newdb log file path'',replace,stats=10,norecovery,nounload"

推荐答案

您认为这意味着什么:它在还原过程中."是一个很大的线索.

还原可能需要很多时间.请耐心等待，并为您的备份感到高兴...

What do you think it means: "It is in the middle of a restore." is a pretty big clue.

Restores can take a lot of time. Be patient, and be glad you had a backup...

这篇关于错误:无法打开数据库X，它在还原过程中.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！