I will make it look simpler to u guys...
DB1 - Backup for Day 1
Log1 - Log backup for day 1
T1
T2
T3
Different transactions throughout the day
Db2 - Backup for Day 2
Log2 - Log backup for day 2
Now i need to restore the database till T2( i will assume that i know
approx time for T2)
Now what can i do for it.......
Thanks in advance...
RVG
sql@hayes.ch (Simon Hayes) wrote in message news:<60cd0137.0308260211.590d151c@posting.google. com>...[color=blue]
>
raj_chins@rediffmail.com (Rajesh Garg) wrote in message news:<14215add.0308252229.7c96983a@posting.google. com>...[color=green]
> > I have a scenario like this.......
> >
> > update esan set tes_address_city = 'TEST1' --at some time
> > update esan set tes_address_city = 'TEST12' --at some time
> > update esan set tes_address_city = 'TEST123' --at some time
> >
> > backup database TESTWMS to disk = 'D:\temp\RecoveryTest\TESTWMS.db'
> > backup log TESTWMS to disk = 'D:\temp\RecoveryTest\TESTWMS01.log'
> >
> > I take these backups at the end of day....
> > Now i want to recover till the second update ie 'TEST12'...
> > Assumptions to be made:-
> > I dont know the timing of the updates.
> > I am allowed to take back only once.
> > We can also assume to have a backup of the previous day also.
> >
> >
> > Is this possible and how can i do it.......
> > Please help me ...and urgent also.......
> >
> > Thanks in advance
> > RVG[/color]
>
> From your description, no, it's not possible. Point in time recovery
> is only possible if a) you have transaction log backups and b) you
> know what time to recover to. See "Selecting a Recovery Model" and
> "Recovering to a Point In Time" in Books Online for more information.
>
> In the future, you might want to consider doing a full database backup
> every night, but a transaction log backup at regular intervals through
> the day. That will give you much better recovery possibilities.
>
> There is a product that can help you recover to a specific transaction
> (instead of a specific time) -
http://www.lumigent.com - however it
> requires transaction log backups, which your description suggests you
> don't have.
>
> Simon[/color]
