SQL恢复数据库问题 [英] SQL Recovery Database problem

问题描述

我的问题：我使用.bak旧文件恢复而不是当前数据库的备份（.bak文件）的真实数据库。任何人都可以帮我展示如何将我的数据库恢复到当前数据库？

My Problem: I used the .bak old file restore over the real database without backup (.bak file) of the current database. can anyone help me show how to recovery my database to the current database?

推荐答案

所以：你已经通过实时数据库恢复了错误的备份而你没有当前备份，但您想在还原之前还原实时数据吗？是的？



您处于所谓的深度麻烦

AFAIK，数据库恢复操作没有撤消，所以你基本上有两个选择：

1）检查你是否在Windows中启用了卷阴影 - 如果是这样，你可以从那里恢复一些东西。

2）检查你的整个PC备份，看看你最近有什么。



首先要做的是去找你的老板并承认 - 他很快就会发现，你可以通过自己告诉他而不是让他意识到，你可以转移一些你完全应得的愤怒。他也可能知道你没有的备份。



但你遇到麻烦，除非你的公司有一个好的备份方案/灾难恢复计划，我怀疑你可能需要开始寻找新的工作...取决于数据库携带的信息。

So: you have restored the wrong backup over the live database and you don't have a current backup, but you want to restore the live data before you restored over the top of it? yes?

You are in what is known as "deep trouble"
AFAIK, there is no "undo" for database restore operations, so you have basically two options:
1) Check if you have Volume Shadowing enabled in Windows - if so, you may be able to restore something from there.
2) Check your whole-PC backups as see if you have anything recent.

The first thing to do is go to your boss and confess - he is going to find out soon enough and you may be able to deflect some of the ire that you are fully due by telling him yourself instead of letting him become aware. He also may know of backups that you don't.

But you are in trouble and unless your company has a good backup regimen / disaster recovery plan, I suspect you may need to start looking for a new job...depending on what info the DB carries.

如果你恢复旧的dB，那么你删除了它，除非你有一个更新的备份，你可以运行完整的日志文件，它就会丢失。

If you restored over your old dB, then you erased it, unless you have a newer backup, out complete log files you can run, it is lost.

你好b $ b

这个时间点可以做的不多但是想到了可能对你有所帮助。



您应该定期检查数据库的完整性，以便采取措施将数据丢失降至最低。如果您想知道如何操作，请查看以下链接： http://technet.microsoft.com/ en-us / library / ms176064.aspx



维护定期备份，这样如果您发现任何数据库不一致的损坏，您将能够执行修复和轻松恢复过程。看看你将如何做到这一点： http://technet.microsoft.com/en-us /library/ms187510.aspx



如果您不太了解恢复过程，仍需要对MDF或BAK文件执行恢复，那么我建议您需要查看这些Wikihow页面，以便更好地了解如何使用专门的恢复软件来实现这一目标。

http://www.wikihow.com/Perform-MS-SQL-Database-Recovery-Through-Software

HTTP ：//www.wikihow.com/Repair-MS-SQL-Server-Backup-%28.Bak%29-Files-with-the-Help-of-SQL-Backup-Recovery-Software



去检查这些解决方案是否对您的事业有所帮助。

问候

Hi
Not much can be done at this point of time but thought it might help you a bit.

You should check integrity of your database on regular interval of time so that measures can be taken to minimize the data losses. If you wish to know how to do that check the below link: http://technet.microsoft.com/en-us/library/ms176064.aspx

Maintain regular backup so that if you find any database inconsistency of corruption you will be able to perform repair and restore process easily. Check out how you will be able to do that: http://technet.microsoft.com/en-us/library/ms187510.aspx

If you are not much aware of the recovery process and still needs to perform recovery on MDF or BAK files then I suggest you to check go through these Wikihow Pages to understand better how you will be able to do that by using specialized recovery software.
http://www.wikihow.com/Perform-MS-SQL-Database-Recovery-Through-Software
http://www.wikihow.com/Repair-MS-SQL-Server-Backup-%28.Bak%29-Files-with-the-Help-of-SQL-Backup-Recovery-Software

Go and check if these solutions help you in your cause.
Regards

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