|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
|
I tried to copy stored procedure and some tables were deleted
thank you Samuel Shulman wrote:
> I tried to copy stored procedure and some tables were deleted Ok.> > thank you 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 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 >  |
|||||||||||||||||||||||
Other interesting topics