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

How to solve the corrupted logfies issue Expand / Collapse
Author
Message
Posted Tuesday, August 7, 2012 9:31 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 21, 2016 2:23 AM
Points: 215, Visits: 645
Hi All,

Here I am new to this. so i want to know how to solve the corrupted log file.
Post #1341666
Posted Tuesday, August 7, 2012 10:55 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, June 21, 2016 4:01 AM
Points: 167, Visits: 1,365
Do you have backup??
If you don't have backup then there is only one way to resolve log file corruption that is to rebuild log file. Check this article, it will help you to handle log file corruption: http://www.recoverdatabase.blogspot.com/2012/07/how-to-deal-with-log-file-corruption.html


SQL Database Recovery Expert
Post #1341673
Posted Wednesday, August 8, 2012 12:46 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 21, 2016 2:23 AM
Points: 215, Visits: 645
Thank You very much
Post #1341697
Posted Friday, August 31, 2012 3:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:48 AM
Points: 4, Visits: 2
For your Log File corruption you can use restore this if you have backup and it also necessary that your backup have all the data which you required.

If you not have any backup so corrupt log file should be restored with help of any third party data recovery software just link Kernel for SQL Server. you can use this software for your corrupted log file.
Post #1352661
Posted Monday, September 3, 2012 8:59 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, June 14, 2016 8:54 AM
Points: 1,631, Visits: 1,600
prettsons (8/7/2012)
Do you have backup??
If you don't have backup then there is only one way to resolve log file corruption that is to rebuild log file. Check this article, it will help you to handle log file corruption: http://www.recoverdatabase.blogspot.com/2012/07/how-to-deal-with-log-file-corruption.html


You should delete that blog post. That is very, very bad advice. You should NEVER detach a corrupted database. It is very likely that the database won't be able to shut down cleanly and then the database won't be able to be reattached and now instead of having just a corrupted log file, you will have lost the entire database.

Read this article by Paul Randal: http://www.sqlskills.com/BLOGS/PAUL/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx




My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master, SQL Server MVP
Principal Database Architect (consultant) at DB Best Technologies
Post #1353570
Posted Monday, September 3, 2012 9:06 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 @ 11:39 AM
Points: 44,728, Visits: 42,596
Never, never, never, never detach a corrupt or suspect database. It will not help and it is very likely to make matters far worse.
Take a look at this article. http://www.sqlservercentral.com/articles/65804/

As for the DB with the corrupted log, if you have a good backup, restore it. If the DB is in full recovery and you have scheduled log you'll be able to restore with minimal data loss.
If you don't have a backup, you're in a world of hurt... I hope that's not the case.



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 #1353574
Posted Thursday, September 6, 2012 2:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 4, 2016 10:00 PM
Points: 18, Visits: 504
I also agree with that never go for detach option if database is in suspected mode it will make situation more worse.
You can rebuild new log file if there is no option left.
Post #1355106
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse