如何在SqlServer2005中找回已删除的表 [英] How To Get Back Deleted Table in SqlServer2005

查看:99
本文介绍了如何在SqlServer2005中找回已删除的表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

Hi Friends ..

由于错误,我从数据库中删除了一个表.如何在sql2005中获取此已删除的表

无论如何,请帮帮我.


谢谢

Randeep Chauhan

Hi Friends..

By Mistake i delete a table from my database.How to get This deleted table in sql2005

In Any idea help me.


Thanks

Randeep Chauhan

推荐答案

您有备份吗?
因为如果不这样做,您几乎必须坐下来从内存中开始输入内容...

SQL Server 2005中没有AFAIK不能删除表.

这就是我一直,持续不断地关注SQL注入攻击的原因之一.

您的表以及其中的所有数据几乎肯定已经消失了.
Do you have a backup?
Because if you don''t, you are pretty much going to have to sit down and start typing from memory...

There is AFAIK no undelete for tables in SQL server 2005.

That is one of the reasons I keep on, and on, and on, about SQL injection attacks.

Your table, and all the data in it, are almost certainly gone for good.


有关此主题的一些讨论供您参考

如何从sql server 2005数据库中恢复已删除的表(http://social.msdn.microsoft.com)
a few discussion on this topic for your reference

How to recover deleted tables from sql server 2005 database (http://social.msdn.microsoft.com)


这篇关于如何在SqlServer2005中找回已删除的表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆