Question Locked

Sql server 2005 Data Base Recover

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Sql server 2005 :
I have Full back up on Weekly basis(on sunday)
I have diff back up on Daily basis.(At 8 AM)
Unfortunately at one day (Tuesday 11 am ) By mistake, i deleted a main table

How would i recover that table.

Please Write the Steps

2 replies

by tony hopkinson

Shutdown the DBMS
Run back up as single user
Full back up
Restore last weekly backup where table still existed
Restore all diferenetials in order upto teh day of the cock up
Export the table, into another db, a file, something.
Restore the mostr recent full back up.
Import the table back in.

That wuill get the table you deleted back to it's state 8 am tuesday.

If you didn't detect teh table had gone walkies until after the differential 8am wednesday, then, you could before exporting restore from that up to just before you delted by perring through the transaction log.

And you should know this....

Ps don't forget to retart the db in normal mode, otherwise you'll look silly.

This discussion is closed to new replies.