Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql2020
Yak Posting Veteran
54 Posts |
 Posted - 2011-06-13 : 22:38:43
|
| HI got below error for sheduled transaction log back up. How to fix this please help on thisBACKUP detected corruption in the database log. Check the errorlog for more information. BACKUP LOG is terminating abnormally."sql2020 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-06-14 : 01:26:59
|
| HiFirst , do a DBCC CHECKDB([MyDB]) WITH ALL_ERRORMSGS, NO_INFOMSGSsee if this returns anything, and check error log Second , check if a Full backup worksJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
sql2020
Yak Posting Veteran
54 Posts |
Posted - 2011-06-14 : 01:41:41
|
| I run DBCC checkdb its not showing any error's full backup also working.sql2020 |
|
|
|
sql2020
Yak Posting Veteran
54 Posts |
Posted - 2011-06-14 : 01:57:31
|
| Here the solution steps1)Switch to simple recovery model2)checkpoint3)Switch to full recovery model4) full backup5) transaction log backupnow its resolved thank you :)sql2020 |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-14 : 02:03:41
|
| You need to do some root cause analysis. Something corrupted the log. Look for IO-related errors, out of date firmware, etc. Before the corruption hits in your data file.--Gail ShawSQL Server MVP |
|
|
|
sql2020
Yak Posting Veteran
54 Posts |
Posted - 2011-06-14 : 02:17:33
|
| HI,Can i know how to do IO-related errors. please let me know. i am new to this please help me on thisThank yousql2020 |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-14 : 04:22:45
|
| System event log, RAID logs, SAN logs, etc, etc. Speak to your storage admin or server admin.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Transaction log backup error