SQL Writer and SQLVDI errors causing backup to fail

• benaro.integrity

  SSC Veteran

  Points: 239

  More actions

  July 2, 2014 at 7:54 am

  #296131

  I have little idea about SQL servers. My SBS 2011 server's backup is failing every time it runs. It has sharepoint and wsus which work with sql databases. I realized the following errors any time I run the server backup using windows backup[GUI] or wbadmin[cmd].

  Log Name: Application

  Source: SQLWRITER

  Date: 7/1/2014 1:18:05 PM

  Event ID: 24583

  Task Category: None

  Level: Error

  Keywords: Classic

  User: N/A

  Description:

  Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013

  Error state: 1, Severity: 16

  Source: Microsoft SQL Server Native Client 10.0

  Error message: BACKUP DATABASE is terminating abnormally.

  SQLSTATE: 42000, Native Error: 3271

  Error state: 1, Severity: 16

  Source: Microsoft SQL Server Native Client 10.0

  Error message: A nonrecoverable I/O error occurred on file "{A29E5835-30A3-4DA2-89A3-8A9A80196C7E}3:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).

  SQLSTATE: 01000, Native Error: 4035

  Error state: 1, Severity: 0

  Source: Microsoft SQL Server Native Client 10.0

  Error message: Processed 0 pages for database 'SharePoint_ConfigurationDatabase', file 'SharePoint_ConfigurationDatabase' on file 1.

  Log Name: Application

  Source: SQLVDI

  Date: 7/1/2014 1:18:05 PM

  Event ID: 1

  Task Category: None

  Level: Error

  Keywords: Classic

  User: N/A

  Description:

  SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=2488. Thread=10456. Server. Instance=SHAREPOINT. VD=Global\{A29E5835-30A3-4DA2-89A3-8A9A80196C7E}7_SQLVDIMemoryName_0.

  I have about six databases on the server so the error occurs for each of them.

  If I use SQL server management studio to backup each of the server, it is successful.

  How do I resolve these errors so I can backup the whole server?