Event ID: 18272 errors when running a backup.

Compresses, encrypts, secures and monitors SQL Server backups.

Event ID: 18272 errors when running a backup.

Postby De Jager Laubscher » Wed Jun 11, 2014 2:51 pm

We are running a SQL Backup job at 1:00 in the morning but we get the following Event ID: 18272 This previously worked fine but only started in the last couple of days.

Log Name: Application
Date: 2014/06/11 05:20:18 AM
Event ID: 18272
Task Category: Backup
Level: Error
Keywords: Classic
User: MURZA\\*********
Computer: ********.murza.co.za
During restore restart, an I/O error occurred on checkpoint file 'G:\\SQL Backup\\RestoreCheckpointDB15.CKP' (operating system error 1784(failed to retrieve text for this error. Reason: 15105)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<Provider Name="MSSQLSERVER" />
<EventID Qualifiers="49152">18272</EventID>
<TimeCreated SystemTime="2014-06-11T03:20:18.000000000Z" />
<Security UserID="**********" />
<Data>G:\\SQL Backup\\RestoreCheckpointDB15.CKP</Data>
<Data>1784(failed to retrieve text for this error. Reason: 15105)</Data>

Does anyone know what causes this, on online forums they all say I must log a call with redgate software.

I also can't seem to find a network or san issue causing this.

Please help
De Jager Laubscher
Posts: 1
Joined: Wed Jun 11, 2014 2:36 pm

Postby petey » Mon Jun 16, 2014 12:56 am

Do the fixes described in this document (http://support.microsoft.com/kb/2022254) address your issue?
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Posts: 2309
Joined: Sun Apr 24, 2005 12:34 pm

Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests