Recovering the deleted Table

Hi,
I have deleted the table from sql server2000 database by mistake. Is there any way to recover it?It's very urgent.
Thanks in advance.Q1 I have deleted the table from sql server2000 database by mistake. Is there any way to recover it?It's very urgent.


A1 Yes.

1 Restore the most recent DB backup dump to a differently named DB. For example: TestDB

2 Use a script and an insert statement, or DTS, or a select into statement, etc., to 'copy' (recreate & populate) the table back to the production DB from the TestDB. Depending on the technique used you may need to reapply permissions, constraints, etc., etc..|||Hi,
My problem is I don't have the back up of it. Is there any other way say by using the log file or any other?
Thanx|||Q1 I don't have the back up of it. Is there any other way say by using the log file or any other?

A1 If ddl scripts for the table(s) exist somewhere, the dropped tables may be recreated by running them.

As far as using the log for recovery, the answer is generally no. However, (provided certain conditions are met), a product like log explorer may sometimes be of help in addressing such kinds of situations. {Such products and methods are not a substitute for backup dumps.} See: http://www.lumigent.com/products/le_sql/le_sql.htm|||Data saved to LDF (LOG) files depend on recovery schema used.
MDF stores current (commited) state of database.
In full recovery schema, LDF stores all ops after last backup.
Then LDF can be used to locate changes and MDF can contain
deleted data.

That was theory...
Does anybody know somebody able to display info stored in SQL database binaries ...|||Originally posted by ispaleny
Does anybody know somebody able to display info stored in SQL database binaries ...
So DBA does.sql