restoring dropped table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » restoring dropped table

restoring dropped table

Rate Topic

Display Mode

Topic Options

Author

Message

selvisirumalar.mariasusai

Posted Thursday, October 18, 2007 10:54 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 11, 2008 10:56 PM
Points: 7, Visits: 27

Hi ,

Accidentally a script deleted certain tables in my sql server database.
Is there any means by which I can restore the table data.
I used the command "FLASHBACK TABLE tcm_counter TO BEFORE DROP"
but it is not working out.
Please help me in restoring the table.

Post #412556

michaela

Posted Thursday, October 18, 2007 11:19 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:21 PM
Points: 1,389, Visits: 417

You can do flashback in Oracle, not sql.
Restore your db to a copy - make sure you don't overwrite your mdf and ldf - from a backup that has the table you're after.
Then create the table structure on your db (CREATE TABLE...)
Then run INSERT INTO your_db.dbo.tblname SELECT * FROM copy_db.dbo.tblname
Check and drop the copy_db.
You restore from a backup only the whole db, not separate object within.
Good luck

Post #412558

VSVaidya

Posted Thursday, October 18, 2007 11:54 PM

SSCrazy

Group: Banned Members
Last Login: Thursday, May 09, 2013 8:14 AM
Points: 2,303, Visits: 300

The easiest way of restoring a database is by means of using database publishing wizard. The feature of using this wizard, is it will carry both schema & data of all the objects of a particular database. Provided, if you have the very latest script file of this, you can do so.

Post #412565

selvisirumalar.mariasusai

Posted Friday, October 19, 2007 2:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 11, 2008 10:56 PM
Points: 7, Visits: 27

Hi ,

Thanks for your reply .
But I couldn't articulate the following line of yours.

" Restore your db to a copy - make sure you don't overwrite your mdf and ldf - from a backup that has the table you're after. "

I dont have any latest back up of my db..
Is it possible to do something with the transaction log ..

regards
M.Malar.

Post #412623

Andras Belokosztolszki

Posted Friday, October 19, 2007 3:43 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367, Visits: 1,585

Have a look at Red Gate's SQL Log Rescue. It will restore your table based on the transaction log and earlier backups. It is a free tool and it works with 2000 only.

Disclaimer: I work for Red Gate, and I wrote the engine of the tool in question.

Regards,
Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Post #412650

selvisirumalar.mariasusai

Posted Tuesday, October 23, 2007 6:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 11, 2008 10:56 PM
Points: 7, Visits: 27

Dear Andras,

I have downloaded the tool. It works fine.

Really such a nice tool and very user friendly also.
So so thanks.

I was able to recover certain tables but not all the tables .

Anyhow thanks a lot.

Post #413864

selvisirumalar.mariasusai

Posted Tuesday, October 23, 2007 7:00 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 11, 2008 10:56 PM
Points: 7, Visits: 27

Andras,

I have downloaded the tool .
It works fine.

It is a very nice tool and very userfriendly.

I could retrive certain tables but not all the tables.

Anyhow thanks a lot for you ..

Post #413868

« Prev Topic | Next Topic »

Permissions