I have actually extended my request
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
Extension is here
Suppose that ou database is crashing at 2.30 and i run the restore
RESTORE DATABASE TESTWMS FROM DISK='D:\temp\RecoveryTest\TESTWMS.DB'
with norecovery --Prev day log
RESTORE LOG TESTWMS FROM DISK='D:\temp\RecoveryTest\TESTWMS01.log'
with norecovery
RESTORE LOG TESTWMS FROM DISK='D:\temp\RecoveryTest\TESTWMS02.log'
with recovery, STOPAT = '2003-08-26 16:37:45.870'
i get message like this
This log file contains records logged before the designated
point-in-time. The database is being left in load state so you can
apply another log file.
RESTORE LOG successfully processed 0 pages in 0.389 seconds (0.000
MB/sec).
Now when i try to run a
Select * i get message lke
Server: Msg 927, Level 14, State 2, Line 1
Database 'TESTWMS' cannot be opened. It is in the middle of a restore.
How do i solve this problem. One way is to use a NO_TRUNCATE with a
backup in between (ie incase of database corruption).
But i dont want to use a log backup once again. I should be able to
solve it without using a log backup once again. In shot backup only
once a day. Aslo i need to refer to a database to that particular
point of time from my backup.
Thanks in advance
RVG