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
sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>...
ra*******@rediffmail.com (Rajesh Garg) wrote in message news:<14**************************@posting.google. com>... 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
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