在SQL Server中还原数据库 [英] restoring database in sql server

问题描述

尊敬的朋友，我在恢复数据库时遇到问题.它已成功完成90％，但剩余的10％将无法完成.请告诉我问题出在哪里，我该如何解决?

Dear friends i got a problem when restoring my database. it is 90% completed successfully but remaining 10% will not complete. pls tell me what was the problem and how can i solve that?

推荐答案

可能有很多原因:您的数据库可能有一些开放的连接. >
首先，右键单击数据库，然后单击分离".它将打开分离数据库"对话框.在框中，它将显示数据库列表以及一些复选框和消息列.不要单击任何复选框或确定".
在消息列中，它将显示链接，显示为"2 Active Connections".如果自然存在任何活动连接，则该过程将不会成功.

如果这是项目的生产数据库或暂存数据库，请在执行其他任何操作之前小心并与DBA交谈.

-Milind

There could be many reasons: You may have some open connection on the database.

First, right-click the database and click "Detach". It will open a "Detach Database" dialog box. In the box, it will show you list of database and some checkboxes and message column. DO NOT click any checkbox or OK.
In the message column, it will show you link which will read "2 Active Connections". If there are any active connection naturally, the process will not succeed.

If this is production or staging database of your project, be careful before doing anything else and talk to DBA.

-Milind

这篇关于在SQL Server中还原数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！