Random failures of transaction log backups Error code 15105
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\\Tren
Write on "F:\\SQLTrnLogBackup\\Tren
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.
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\\Tren
Write on "F:\\SQLTrnLogBackup\\Tren
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'd agree with Nakul - get your data backed up off that drive, replace it, and give it a thorough check-out.
Mike
Mike
ASKER
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.
Well, as I said, start getting good backups set up somewhere else. Good luck.
Mike
Mike
ASKER
No-where near, still 279GB free on the drive I save my log files to.
Any other suggestions?
Thank you.