Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

recover database only have log file Expand / Collapse
Posted Wednesday, July 16, 2008 3:45 AM



Group: General Forum Members
Last Login: Tuesday, May 31, 2016 4:58 AM
Points: 16, Visits: 133
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)
Post #535037
Posted Wednesday, July 16, 2008 8:35 AM



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
Do you have the transaction log backups from the time of the last full backup?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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
Posted Wednesday, July 16, 2008 9:17 AM



Group: Administrators
Last Login: Today @ 8:38 AM
Points: 34,366, Visits: 18,586
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
Posted Wednesday, August 6, 2008 5:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Thursday, August 7, 2008 9:56 PM



Group: General Forum Members
Last Login: Thursday, January 8, 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.
"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 »

Add to briefcase

Permissions Expand / Collapse