Solved

Random failures of transaction log backups Error code 15105

Posted on 2016-08-14
7
65 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 46

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now