在SQL Server中恢复删除记录 [英] recovered delete records in sql server

问题描述

如何在实时服务器中获取sql server 2008数据库中表的已删除记录.
在此先感谢

How to get deleted record of table in sql server 2008 database in live server.
thanks in advance

推荐答案

可能-或不可能-

首先要做的是:告诉老板.无论如何，他很有可能会找出来，而试图隐藏它看起来并不好.

第二:您最近的备份多大了?如果还不算太老，那么这是练习公司灾难恢复程序的好时机.

第三:Redgate可能会提供帮助. http://www.red-gate.com/products/dba/sql-log-rescue / [ ^ ]仅适用于SQL 2000，但是它将使您大致了解要查找的内容.


之后:您正在使用实时服务器做什么?最好的时候愚蠢的举动...当你起床时，备份一次，然后经常做！

It may - or may not - be possible.

The first thing to do is: tell your boss. There is a very good chance that he is going to find out anyway, and just trying to hide it does not look good.

Second: How old is your most recent backup? If it isn''t too old, then this is a good time to practice your companies disaster recovery procedures.

Third: Redgate may be able to help. http://www.red-gate.com/products/dba/sql-log-rescue/[^] is only for SQL 2000, but it will give you an idea what to look for.


After that: What were you doing playing with the live server? Silly move at the best of times... When you are up, take a backup, and then do them often!

这篇关于在SQL Server中恢复删除记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！