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

Backup Failed SQL 2005 Expand / Collapse
Author
Message
Posted Monday, April 14, 2014 12:53 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Hi,

I cant able to take the database full backup its says database log file is corrupted. Please find the attached screenshot for your ref.

Its very urgent. Please help on this.



Pradeep

  Post Attachments 
backup error.JPG (14 views, 151.92 KB)
Post #1561336
Posted Monday, April 14, 2014 12:59 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Have you checked the error log? What information captured in it? Is this production server? Have you executed DBCC CHECKDB?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1561339
Posted Monday, April 14, 2014 1:25 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Yes its a production server and already executed DBCC CHECKDB command but there was no error found.

Pradeep
Post #1561348
Posted Monday, April 14, 2014 3:35 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
You haven't updated error from sql error log?

Can you restore with command line?

BACKUP DATABASE <DBNAME> TO DISK = '<PATH>'


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1561400
Posted Monday, April 14, 2014 3:53 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 11:08 AM
Points: 859, Visits: 451
Use backup log with TRUNCATE_ONLY option to truncate the log entries from .ldf file and run a full backup. It should work. But I would really recommend to have your I/O subsystem checked once with people who are responsible to manage this...
Post #1561409
Posted Monday, April 14, 2014 3:59 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 5:02 AM
Points: 39,866, Visits: 36,207
What does the error log say?


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 #1561414
Posted Monday, April 14, 2014 4:20 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Error log is :

Backup detected log corruption in database Wss_Content. Context is Bad Middle Sector. LogFile: 2 'D:\Data\xxxx_log.ldf' VLF SeqNo: x280d VLFBase: x10df10000 LogBlockOffset: x10efa1000 SectorStatus: 2 LogBlock.StartLsn.SeqNo: x280d LogBlock.StartLsn.Blk: x8477 Size: xcc00 PrevSize: xec00


Pradeep
Post #1561420
Posted Monday, April 14, 2014 4:22 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 5:02 AM
Points: 39,866, Visits: 36,207
Oooh, a sharepoint content database...

Switch the database into simple recovery, checkpoint, checkpoint, checkpoint, (and a few more just to be sure), switch the DB back to full recovery and take a full backup, then you should be able to resume both full and log backups without error.

Then get the storage people to have a look at the IO subsystem for problems.



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 #1561421
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse