Solved

Random failures of transaction log backups Error code 15105

Posted on 2016-08-14
7
69 Views
Last Modified: 2016-08-15
Heyas,

I am getting the following error in the logs:

Failed:(-1073548784) Executing the query "BACKUP LOG [Trend TO  DISK = N'F:\\SQLTrnL..." failed with the following error: "Write on "F:\\SQLTrnLogBackup\\Trend\\Trend_backup_2016_08_14_214004_6899647.trn" failed: 112(failed to retrieve text for this error. Reason: 15105)
Write on "F:\\SQLTrnLogBackup\\Trend\\Trend_backup_2016_08_14_214004_6899647.trn" failed: 112(failed to retrieve text for this error. Reason: 15105)
BACKUP LOG is terminating abnormally.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

I've already tried the following fix but it hasn't worked:

http://blogs.lostincreativity.com/sqldba/fix-operating-system-error-5-failed-to-retrieve-text-for-this-error-reason-15105-microsoft-sqlserver-smo/

How else would I troubleshoot this issue?

Thank you.
0
Comment
Question by:Zack
7 Comments
 
LVL 16

Accepted Solution

by:
DcpKing earned 250 total points
ID: 41755825
It's a disk-write fail, but the reporter is too high up to know why.
Assuming that you've not got a failing disc, you're not writing to the root of C: (you're not), and that the destination file does not already exist, ... take a look at the disc and make sure you're not out of space!

hth

Mike
0
 

Author Comment

by:Zack
ID: 41755889
Hi DcpKing,

No-where near, still 279GB free on the drive I save my log files to.

Any other suggestions?

Thank you.
0
 
LVL 12

Assisted Solution

by:Nakul Vachhrajani
Nakul Vachhrajani earned 125 total points
ID: 41756161
I agree - it looks like an impending disk failure. Can you try running chkdsk to check the disk for file system errors and also check for bad sectors?
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 47

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 125 total points
ID: 41756203
How big is the transaction log?
Can you try to backup to a different disk to see if the error persists?
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 41757257
I'd agree with Nakul - get your data backed up off that drive, replace it, and give it a thorough check-out.

Mike
0
 

Author Closing Comment

by:Zack
ID: 41757268
Thanks guys for the advice I will check that specific disk on the SAN. It will probably take a week, for the SAN team to schedule that though finalising question now.
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 41757281
Well, as I said, start getting good backups set up somewhere else. Good luck.

Mike
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question