Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

restoring dropped table Expand / Collapse
Author
Message
Posted Thursday, October 18, 2007 10:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, October 18, 2007 11:19 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 8:19 PM
Points: 1,393, Visits: 438
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
Posted Thursday, October 18, 2007 11:54 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: Banned Members
Last Login: Sunday, September 7, 2014 11:11 PM
Points: 2,622, Visits: 328
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
Posted Friday, October 19, 2007 2:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, October 19, 2007 3:43 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen 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
Posted Tuesday, October 23, 2007 6:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, October 23, 2007 7:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse