Error V-79-57344-33938 on backing up large SQL Server 2005 DB with Veritas Backup Exec 10d

An error occurred on a query to database **YourDB**
V-79-57344-33938 – Write on “**YourDB**_00__7091c250_56c1_4f5e_9bf8_3eced26e1926_” failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)

We’ve been getting this error backing up our main SQL Server 2005 (SP1) database which has Full recovery mode with a 4GB data file and 35Gb transaction log. Searched about a bit and found various articles referring to the the VDI and guessed it was due to SQL Server not being able to put the temporary backup file to disk – I was write.
Basically ensure that there’s sufficient space on %TEMP% to hold it!
We had ours set to a partition with just 20Gb space – I had %TEMP% set to a couple of 15k rpm 36Gb SCSI disks.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s