Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > Re: How to reco...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 3 Topic 10997 of 11422
Post > Topic >>

Re: How to recover deleted records?

by Helmut Woess <user22@[EMAIL PROTECTED] > Apr 24, 2008 at 02:44 PM

Am Thu, 24 Apr 2008 01:06:28 -0700 (PDT) schrieb nano2k:

> Hello
> 
> I accidentaly ran a DELETE command against a table with a wrong WHERE
> clause.
> My database had no backup, but the recovery model was Full.
> I am using SQL Server 2005.
> 
> Is there a way, or any utility software that could help me recover the
> lost data?
> The .ldf file is twice as big than the .mdf file, so I think that my
> records are still there in the .ldf file.
> 
> Thanks.

I don't know a way to read the log file. And the only tool i know which
can
possibly help you is Apex SQL Log, but it has it's price:
http://apex-sql-log.apex-sql-llc.qarchive.org/

bye,
Helmut
 




 3 Posts in Topic:
How to recover deleted records?
nano2k <adrian.rotaru@  2008-04-24 01:06:28 
Re: How to recover deleted records?
Helmut Woess <user22@[  2008-04-24 14:44:03 
Re: How to recover deleted records?
Hugo Kornelis <hugo@[E  2008-04-24 16:33:52 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun Oct 12 21:03:21 CDT 2008.