recover database only have log file

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Data Corruption » recover database only have log file

recover database only have log file

Rate Topic

Display Mode

Topic Options

Author

Message

dhaneenja-755935

Posted Wednesday, July 16, 2008 3:45 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, June 13, 2013 2:05 AM
Points: 14, Visits: 123

Hi all,
How to recover database only have log file (Recovery mode FULL) and mdf file corrupted
we have few months back full backup

Tharindu Dhaneenja.
MCTS,MCITP(SQL Server),OCA(Oracle)
http://dhaneenja.blogspot.com

Post #535037

GilaMonster

Posted Wednesday, July 16, 2008 8:35 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:41 AM
Points: 38,089, Visits: 30,383

Do you have the transaction log backups from the time of the last full backup?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #535259

Steve Jones - SSC Editor

Posted Wednesday, July 16, 2008 9:17 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526, Visits: 13,864

If the MDF file is corrupted, and you're sure, first make a copy of it and the LDF files immediately. That way someone can help you. If you can run a last transaction log backup (tail backup) do that.

If you have a full backup, when is it from and what log backups to you physically have now?

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #535324

ch.mohini

Posted Wednesday, August 06, 2008 5:31 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 28, 2008 6:48 PM
Points: 35, Visits: 174

restore full with no recovery & log back ups

Post #547402

Coyote Blue

Posted Thursday, August 07, 2008 9:56 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 08, 2009 6:13 PM
Points: 134, Visits: 44

My two cents; bcuz I used to have to manage the Disaster Recovery Handbook for my last employer (and this is not just for DB recovery...)

"Your Data Backup is only as trustworthy as your last test restore. Any data beyond that should be considered suspect.
And---
"Your Disaster Recovery model is only as good as your last survived disaster. "

Not saying you should test restore every day,,, but you should at random intervals test your backups and your recovery models.

Post #548844

« Prev Topic | Next Topic »

Permissions