To recover corrupted database

Tech-Archive recommends: Fix windows errors by optimizing your registry



Hi,

I have a test database. In case if the database is corrupted, how can I
retrieve
the database. I heard that using log transaction files we can retrieve the
DB.
But I don't know how?
The DB is in Simple recovery mode.

I want to know how can i recover a corrupted database?
and deleted database?

Thanks,
Soura
.



Relevant Pages

  • Re: Help - Timing Logic
    ... from the database ... ... now you either need to incorporate a locking procedure ... ... opposed to building the transaction in the code. ... implement as above locking only the records you retrieve / update - need ...
    (microsoft.public.dotnet.languages.vb)
  • Re: OT: MySQL versus PostgreSQL and database design
    ... to retrieve all the events at once. ... can make that a primary key in the database. ... likely to want to retrieve all at once, without any sorting. ... different the event types are -- if they've all got exactly the same ...
    (rec.crafts.metalworking)
  • Re: Getting a (non-radio) buttons index number from array
    ... index in the Comment array of the button that was fired. ... you don't need js if you print out the full DOM ... There needs to be some unique way to identify the row in the database. ... Then it's easy to retrieve the ...
    (comp.lang.php)
  • Re: OT: MySQL versus PostgreSQL and database design
    ... to retrieve all the events at once. ... in a way that you can avoid any real searching in your application, ... can make that a primary key in the database. ... I was thinking of sorting the events into different tables so that each table contains one type of event - specifically a subset of events that I'm likely to want to retrieve all at once, ...
    (rec.crafts.metalworking)
  • Re: Help - Timing Logic
    ... If you DBA screams and yells and jumps up and down - this is a database server, we are not install you little program on it ... ... Retrieve list of messages from the database... ... will create a lot of wasted CHECKING and UPDATING and DATABASE LOCKING to ensure messages are not duplicated between recipients. ... Transaction and Database Locking - look at isolation levels / settings ...
    (microsoft.public.dotnet.languages.vb)