Hi
I know there is a way to get the droped tables in oracle databases if you
did not commit after dropping.

I am sure there is a way to do that in SQL2K also.


Best Regards
InfoCom Support

-----Original Message-----
From: Fang, Elaine [mailto:Elaine.[Email Address Removed] Tuesday, July 09, 2002 4:34 PM
To: [Email Address Removed] Just made an error -- need help!!!


Hi list,

It's a test db w/o old backup. I just dropped the tables that I should have
kept. Is that anyway for me to bring them back?

Can I take a backup of the transaction log and restore the db back to the
point that the error was made?

Your quick response will be greatly appreciated!!!

Elaine









---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page