473,327 Members | 2,118 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Urgent Help Required - Recovery

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
Jul 20 '05 #1
1 1885
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

Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Alfred Wallace | last post by:
I work on a debian server. with apache doocroot: /home/web. unfortunatly, the other admin creates a user with /home/web default directory, and then deletes the user... /home/web doesn't exists...
6
by: Rajesh Garg | last post by:
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...
0
by: swaroopa | last post by:
Hello Partner, Please forward some good resumes with excellent communication skills. SQL DBA ANALYST Exp: 4-6YEAR Location: Redmond Duration : 6 Months + Start Date : ASAP
1
by: SpiderSwamy | last post by:
Hi, I know little bit about asp, I am facing a problem in Validating the ASP Form.. Example: Stud ID: 501242016 FirstName: Ajit LastName: Kar
6
by: technocrat | last post by:
i have a process thats in roll back state..i ts going on forever..i need to kill it and would like to restart it with some changes.... if not atleast i need to know the status of the rollback to...
0
by: Johan Neidenmark | last post by:
When i try to run this SQL statements in iSeries Access for windows (against my customers db2) i get: SQL State: 42904 Vendor Code: -7032 Message: SQL procedure, function, or trigger...
0
by: okonita | last post by:
Hi all, I am running a recover tocopy procedure and twice with different image copy I found this informational message AND no data recovered: DSNUCBAL - THE IMAGE COPY DATA SET...
0
by: Okonita | last post by:
Hi all, I am running a recover tocopy procedure and twice with different image copy I found this informational message AND no data recovered: DSNUCBAL - THE IMAGE COPY DATA SET...
2
by: itsvineeth209 | last post by:
My task is to create login control without using login control in tools. I shouldnt use sqldatasource or any other. I should use only data sets, data adapters and data readers etc. U had created...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.