help me...

Question

Post reply

help me...

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 1

dewa_himatif_sf (11/13/2007)
and a few others ...
//what's the recovery model of the DB?
simple

Sorry everybody, but dewa's already said it's in Simple mode. :crying:

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Minaz Amin SSChampion Points: 11052 More actions · Answer 2

Take care when handling important data !!

Minaz

"More Green More Oxygen !! Plant a tree today"

dewa_himatif_sf Grasshopper Points: 16 More actions · Answer 3

thanks all,

i download apexSQL log (trial version) in my office OS (Win 2000 Server), before install apexSQL log, i should install windows intaller 3.0 and .NET Framework 2.0, then i install apexSQL log.

i run apexSQL log, then i choose recovery log, and open mydb.ldf, then there are message error that "mode is simple", then i change it to full mode, i run again recovery log,

..................................

i can read the record that i was deleted before in "SQL script",

then i run that SQL script (insert the record to table again).

i'm happy that, but....

i running my application that using myDB,

oh dear, not at all recovery, from around 86.000 record, it's just around 30.000 apexSQL can recovery,

and now my BOSS is very angry to me...

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Were those rows inserted before or after the 9th Nov backup? If before, then restore that backup to another server and copy the data across.

Look on the bright side. It could have been worse. It could have been the entire database getting corrupt.

Now that your DB is in full recovery mode, set up regular transaction log backups to ensure that you can always do a recovery to a specific point in time if required.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Minaz Amin SSChampion Points: 11052 More actions · Answer 5

Thanks for sharing the information !!

Minaz

"More Green More Oxygen !! Plant a tree today"

SQL_ABD SSCertifiable Points: 5832 More actions · Answer 6

Hi,

I think thet Jeff proposition is the only way to recover your lost data (because you have a simple recovery model). to check the data you lost just download a trial version of SQL Data compare. http://www.red-gate.com/.

Then you have to be aware when inserting the deleted rows (Relatioship).

When all will be fine,As an advice, You must also change your backup strategy (change recovery to FULL, to allow you backup transaction log and in future if you have the same situation you will be almost OK)

Regards,

Ahmed

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 7

Jason Selburg (11/14/2007)
Sorry everybody, but dewa's already said it's in Simple mode. :crying:

Yeah, I missed that. Oh well... at least Dewa has the links for a recovery using FULL... 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)