SQL server drop命令 [英] SQL server drop command

问题描述

我错误地删除了SQL Server 2008 R2中的表。是否有任何可能的方法来检索表。使用.bak文件恢复数据库似乎是一个很大的过程.bak文件的大小太大。即使给予用户权限，也可以在数据库中执行DROP语句时引发错误/提供警告？请在这方面提供帮助。

提前致谢。



Manikandan V

Hi,
I dropped a table in SQL server 2008 R2 by mistake.Is there any possible way to retrieve the table.Restoring the database using the .bak file seems to be a big process since the size of the .bak file is too large.Also is it possible to raise error /provide warning when executing the DROP statements in a database even when a user is given permissions? Kindly help in this regard.
Thanks in advance.

Manikandan V

推荐答案

在这里查看：还原和恢复概述（SQL Server） [ ^ ]

您需要创建一个具有不同名称的新数据库，并将.bak文件还原到该数据库中。现在从那里只导出你之前删除的那个表。删除新数据库，你的问题就会解决。



希望，这会对你有帮助......

U need to make a new database with different name and restore the .bak file into that database. Now from there only export that table which u have deleted previously. Drop the new database and your problem will be solved.

Hope,This will help you...

这篇关于SQL server drop命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！