Need to Recover Database

Question

Need to Recover Database

Josh-286994

Newbie

Points: 1
More actions
December 17, 2005 at 2:04 pm

#111572

Hi All -
One of my Database has crashed. I have the full backups and hourly transaction log backups. My DB crashed at 10:35 AM and the lastest Transaction log backup available is of 10:00 AM. If I restore Full and all Transacton log backups, I will have my DB at 10:00 AM state.
I was also able to get the Active Transaction log file (after 10:00 AM) from the disk. Is there a way I can restore this log file too, so that I don't loose
any transactions and get back my database to 10:35 AM state? ( Also, will this result in loosing open/active transactions?)
Regards
Josh

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Bulent Gucuk SSCertifiable Points: 5497 More actions · Answer 1

Hello,

If you have a backup of your last transaction file you can use RESTORE LOG WITH STOPAT 10:34 statement. This way sql server restore your transaction log to a state at 10:34 (since your db corrupted at 10:35) It will probably roll back some transactions but you will recover your db to a point in time. I recommend downloading Brian Knight's 'Real World SQL Server Disaster Recovery' document and read it at least twice a month.

http://www.lumigent.com/go/sd19/

SQLBill SSC Guru Points: 51440 More actions · Answer 2

Make sure you first restore the full backup using the WITH NORECOVERY option.

-SQLBill

Ben Sollis-281768 Newbie Points: 1 More actions · Answer 3

Interesting I went to

http://www.lumigent.com/go/sd19/ to download the recommended document, and they tried to sell me something. never did see any sign of the document itself.

Posts like that should be treated as spam and deleted accordingly !

Ben

sollisb@asaangard.com

SQLBill SSC Guru Points: 51440 More actions · Answer 4

Ben,

I don't know why that poster added that link as it had nothing to do with the question.

Lumigent makes a product called Log Explorer. This product is supposedly (I've never used it, but I've seen lots of comments about it) great for reading Transaction Log files. However, my understanding is that it must be installed before you need to use it. Let's say you have it installed and something happens to your database, but you don't know what or when. Log Explorer will let you read the log file to see what transactions occured. Then you can fix your database based on that.

But the original poster knew what went wrong and when.

-SQLBill

Bulent Gucuk SSCertifiable Points: 5497 More actions · Answer 5

I have included the link to lumigent site (that's where I downloaded a while ago) for the original poster to download very good pdf document full of disaster recovery, backup and restore how to's (for newbies like me and original poster)that Brian Knigth has wrote. Since you (sqlbill) has over 1500 posts I believe you have heard about Brian Knight before. If anyone interested contact me and I will email you the document.

SQLBill SSC Guru Points: 51440 More actions · Answer 6

Yes, I know of Brian Knight. I would suggest checking out the articles on this website. You can check out articles by specific authors or just all the articles. Brian Knight might have that article or a similar one posted here. If not, there are lots of other articles about disaster recovery on this site.

-SQLBill