|
Home > Archive > MS SQL Server Tools > March 2006 > urgent
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Samuel Shulman 2006-03-22, 11:30 am |
| I tried to copy stored procedure and some tables were deleted
thank you
| |
| David Gugick 2006-03-22, 1:31 pm |
| 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
| |
| Samuel Shulman 2006-03-22, 1:31 pm |
| 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
"David Gugick" <david.gugick-nospam@quest.com> wrote in message
news:ezzgLddTGHA.1572@tk2msftngp13.phx.gbl...
> Samuel Shulman wrote:
>
> 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
>
|
|
|
|
|