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"?
> >
> >
>

restore a database to point in time

Should I need to restore a database to a specific point in
time, assuming full recovery model, are these steps
correct?
1. Back up Transactin Log
2. Restore Last Full backup and any differential backups
before the desired time.
3. Restore Transaction Log to specific point in time.
I am under the assumption that only tranasaction log
backups can be restored to a specific point in time, not
database backups, is this correct?Dan
You are correct that only transaction logs can restore to
a point in time.
If you are using differential backups, you only need to
restore the most recent one.
Your plan should work fine.
Regards
John|||Yes, you can only do point-in-time with transaction log restores.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:0d6d01c39e35$08002b70$a501280a@.phx.gbl...
Should I need to restore a database to a specific point in
time, assuming full recovery model, are these steps
correct?
1. Back up Transactin Log
2. Restore Last Full backup and any differential backups
before the desired time.
3. Restore Transaction Log to specific point in time.
I am under the assumption that only tranasaction log
backups can be restored to a specific point in time, not
database backups, is this correct?