Thursday, March 29, 2012

Backup fails WriteFileEx error !

I had a normal SQL backup fail (one of hundreds that happen every day) with
this error
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:BACKUP DATABASE is terminating abnormally. (Microsoft
OLE DB Provider for SQL Server (80040e14): The WriteFileEx system function
executed on file 'F:\MSSQL\BACKUP\Mocom\RB_Mocom_db_FULL_99.BAK' only wrote
235008 bytes, expected 983040.)
Step Error code: 80040E14
Step Error Help File:
Step Error Help Context ID:0
I can't find any hints on microsoft.com for WriteFileEx or the error numbers.
I suspect its a simple out of space condition, but I can't be sure.
Anyone seen one of these ?
TIA
From oledberr.h file, which ships with the OLEDB SDK:
0x80040E14 The command contained one or more errors
Backup failed for some other reason, but SEM reported a generic error. You
should check your SQL errorlogs for backup errors and post them here.
Adrian
"Jim Trowbridge" <JimTrowbridge@.discussions.microsoft.com> wrote in message
news:DF3297D4-F0E1-4348-9D3A-44E539995F9D@.microsoft.com...
>I had a normal SQL backup fail (one of hundreds that happen every day) with
> this error
> Step Error Source: Microsoft OLE DB Provider for SQL Server
> Step Error Description:BACKUP DATABASE is terminating abnormally.
> (Microsoft
> OLE DB Provider for SQL Server (80040e14): The WriteFileEx system function
> executed on file 'F:\MSSQL\BACKUP\Mocom\RB_Mocom_db_FULL_99.BAK' only
> wrote
> 235008 bytes, expected 983040.)
> Step Error code: 80040E14
> Step Error Help File:
> Step Error Help Context ID:0
> I can't find any hints on microsoft.com for WriteFileEx or the error
> numbers.
> I suspect its a simple out of space condition, but I can't be sure.
> Anyone seen one of these ?
> TIA
>

No comments:

Post a Comment