Home All Groups Group Topic Archive Search About
Author
22 Mar 2006 3:40 PM
Samuel Shulman
I tried to copy stored procedure and some tables were deleted

thank you

Author
22 Mar 2006 5:37 PM
David Gugick
Samuel Shulman wrote:
> I tried to copy stored procedure and some tables were deleted
>
> thank you

Ok.

What?

So you were copying some stored procedures from one database to another
and in the process you accidentally dropped some tables. Not sure how
that happened. In any case, do you have a backup of the database you can
use to restore the dropped objects? If not, do you have a SQL Server log
reader utility you can use to assist in reconstructing the tables
(assuming you are not running in simple recovery model)?

Please give us more information about your environment and what you
might have available to recover the tables. There is no "undo" command
that allows you to recover a dropped table.


--
David Gugick - SQL Server MVP
Quest Software
Author
22 Mar 2006 7:27 PM
Samuel Shulman
The tables were not dropped but the records were deleted (I used the import
data wizard) I do have a log file but I don't have a utility that will help
me undo the changes

btw, the important tables were not deleted so there is no any more panic

Thank you,
Samuel

Show quote
"David Gugick" <david.gugick-nospam@quest.com> wrote in message
news:ezzgLddTGHA.1572@tk2msftngp13.phx.gbl...
> Samuel Shulman wrote:
>> I tried to copy stored procedure and some tables were deleted
>>
>> thank you
>
> Ok.
>
> What?
>
> So you were copying some stored procedures from one database to another
> and in the process you accidentally dropped some tables. Not sure how that
> happened. In any case, do you have a backup of the database you can use to
> restore the dropped objects? If not, do you have a SQL Server log reader
> utility you can use to assist in reconstructing the tables (assuming you
> are not running in simple recovery model)?
>
> Please give us more information about your environment and what you might
> have available to recover the tables. There is no "undo" command that
> allows you to recover a dropped table.
>
>
> --
> David Gugick - SQL Server MVP
> Quest Software
>

AddThis Social Bookmark Button