Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 24, 2014 2:48 AM
Points: 16, Visits: 131
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://www.databaseusergroup.com
Post #535037
Posted Wednesday, July 16, 2008 8:35 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 40,615, Visits: 37,080
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
Posted Wednesday, July 16, 2008 9:17 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:37 AM
Points: 31,363, Visits: 15,826
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


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

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.
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 »

Add to briefcase

Permissions Expand / Collapse