如何恢复我的Sqlserver数据库 [英] How to recover my Sqlserver database

问题描述

遗憾的是我的数据库已被删除如何在硬盘中恢复我的数据库任何解决方案请告诉我

unfortunately my database has been delete how to recover my database in hard Disk any solution please tell me

推荐答案

如果数据库是分离的，你会发现它在您存储数据库的位置。



如果您的数据库已被物理删除，那么无法保证您将获得数据。

尝试使用Undelete +等工具恢复已删除的数据。

If the database was detached, you will find it in the location where you store your databases.

If your database was physically deleted, then there is no guarantee you will get your data back.
Try tools like Undelete+ to restore deleted data.

您是如何删除数据库的？ mdf和ldf文件无法直接删除，因为它们受SQL Server服务保护。你真的删除了数据库还是分离了它？只需检查一下。



如果没有，则检查安装路径中是否存在mdf文件然后下载将恢复已删除数据的软件。如果它最近被删除，则有可能恢复数据库。只需确保在使用软件恢复数据库之前不在同一驱动器上创建任何新文件。

How did you deleted your database? mdf & ldf files cant br deleted directly as they are protected by SQL Server services. Did you really deleted the database or detached it? Just check it.

Also check whether mdf file is present in installation path if not then download software which will recover deleted data. If it is recently deleted, there are chances that database will get recovered. Just make sure that you don't create any new file on the same drive before recovering database with software.

这篇关于如何恢复我的Sqlserver数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！