Hi

I guess you can rollback if you did not commit.


Best Regards
InfoCom Support

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


I doubt that since drop table is DDL instead of DML, which means once it's
done, it can not be roll back, right?

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


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] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page