Wednesday, March 28, 2012

Restore Database.

Hi!
Here some steps :-)
1. Good database "Good"
2. Some wrong transactions done and commited
3. Database contain now wrong data "Bad"
4. Unwanted transactions presents in Tlog
5. There is no backups of Database, at the moment when it was "Good"
Can I, using TLog with transactions and so, knowing what they done, roll
back database from "Bad" state to "Good"?Thank you! Very interesting link.
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:uAG2hGtRDHA.2188@.TK2MSFTNGP10.phx.gbl...
> Since you do not have a database backup, about the only thing you might do
> is to take a look at Log Explorer, it is a tool from Lumigent
> (www.lumigent.com)
> MS doesn' have any tools that come with SQL that can help you out of
this..
> "kirg" <srkr@.mail.ru> wrote in message
> news:OAsyV5rRDHA.3192@.tk2msftngp13.phx.gbl...
> > Hi!
> > Here some steps :-)
> >
> > 1. Good database "Good"
> > 2. Some wrong transactions done and commited
> > 3. Database contain now wrong data "Bad"
> > 4. Unwanted transactions presents in Tlog
> > 5. There is no backups of Database, at the moment when it was "Good"
> >
> > Can I, using TLog with transactions and so, knowing what they done, roll
> > back database from "Bad" state to "Good"?
> >
> >
>

No comments:

Post a Comment