July 10, 2009 at 2:42 pm
Hi ,
By a big Confusion or wrong script One column in database has been changed, i want to restore the Previous values for that column , but we don't have any backup file for that ..
Can i restore in any other way ..
please Thanks in advance
July 10, 2009 at 3:07 pm
You dont have any backups???
July 10, 2009 at 3:17 pm
yeah , i don't have any Backup file ...That's the problem actually ..
only one table need to be updated , How .. i don't have any Back up file
Any other to restore the Table pleaseeeeeeeeeeeeeeee
July 10, 2009 at 3:19 pm
You have never taken a full backup of the database, not even when it was first created?
July 10, 2009 at 3:21 pm
Without a backup - your only other option is going to be a log reader tool. That will only work if your database is in full recovery model and you have backed up the database at least one time.
There are no other options available without a backup.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
July 10, 2009 at 3:22 pm
We have taken the Backup , But I don't have a Access for that ... please advice any other than using Back up
July 10, 2009 at 3:24 pm
What is your current recovery model? If you had to, can you get the most current backup that, you unfortunately say can't at the moment, exists?
July 10, 2009 at 3:28 pm
John Paul (7/10/2009)
We have taken the Backup , But I don't have a Access for that ... please advice any other than using Back up
Without access to backups (that includes transaction log backups), you do not have any other options. I would guess that if you don't have access to the backups - you wouldn't have the privileges or access necessary to utilize a log reader tool either.
If you are not the DBA and don't have access to the backups - then you really need to contact the DBA team and work with them to fix this issue. You are not going to be able to fix this without their help.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
July 10, 2009 at 3:29 pm
Current Recovery model :- FULL ,
I can't access any backup file
July 10, 2009 at 3:31 pm
oh... NO ... Contacting DBA is the BIG task .. they will be shrinking / screwing me into the Database ..i think
July 10, 2009 at 3:32 pm
You aren't going to be able to fix this yourself if you can't access the backups. As Jeffery said, you will need to get help. With access to the backups, including a current t-log backup, the database could be restored under another name using point in time recovery to just prior to the erronous update statement being executed. At that point, you would then be able to recover the data that was erronously updated and fix the data in the current database.
July 10, 2009 at 3:34 pm
Something you should be aware of, trying hide your mistake makes the mistake even bigger. It is best to admit the error and get help fixing it.
July 10, 2009 at 3:39 pm
Ok , Thanks lynn .. I will contact DBA ... I think that is the only way to Fix the Issue ...
by the way ....what's the LOg reader Tool.. can i make use of that tool to slove this issue ...
July 10, 2009 at 3:42 pm
I'd have to Google those. I haven't looked at them. They are supposed to be able to read the transaction log and help recover lost data or database objects. Would it hlep you, depends on what level of access you have on your database. It is possible that even with a log reader tool, you'd have to have assistance from your DBA.
July 10, 2009 at 3:43 pm
Ok got it .. Thanks a lot Lynn
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply