SQL error 701, 3271, 3013, Error Code: -2139684860

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

SQL error 701, 3271, 3013, Error Code: -2139684860

Postby michaeldye » Wed Jul 04, 2012 8:03 am

Good morning;
Here's a snippet from the emailed log from our nightly backup (V7.0.6.x; we've just upgraded to V7.1 this morning - not sure if that'll fix it?!)

03/07/2012 23:23:11: BACKUP DATABASE [?????] TO VIRTUAL_DEVICE = 'SQLBACKUP_D1E1B34C-1773-41F6-9D32-4F6A86D8E051', VIRTUAL_DEVICE = 'SQLBACKUP_D1E1B34C-1773-41F6-9D32-4F6A86D8E05101', VIRTUAL_DEVICE = 'SQLBACKUP_D1E1B34C-1773-41F6-9D32-4F6A86D8E05102' WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (??????), 03/07/2012 23:23:11', DESCRIPTION = N'Backup on 03/07/2012 23:23:11 Server: ?????\\?????? Database: ?????', FORMAT, DIFFERENTIAL

03/07/2012 23:23:22: Thread 0 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
03/07/2012 23:23:22:
03/07/2012 23:23:22: Thread 1 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
03/07/2012 23:23:22:
03/07/2012 23:23:22: Thread 2 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
03/07/2012 23:23:22:
03/07/2012 23:23:23: SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
03/07/2012 23:23:23: SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_D1E1B34C-1773-41F6-9D32-4F6A86D8E051:" 995(failed to retrieve text for this error. Reason: 1815).
03/07/2012 23:23:23: SQL error 701: SQL error 701: There is insufficient system memory in resource pool 'internal' to run this query.

What does it mean, what can we do?

Thanks,

Dr. Michael Dye.
michaeldye
 
Posts: 3
Joined: Tue Apr 03, 2007 4:20 pm

Postby petey » Wed Jul 04, 2012 9:46 am

That is SQL Server raising an error with regards to a memory issue. There are a lot of recommendations on how to address this if you google for 'There is insufficient system memory in resource pool 'internal' to run this query.'.

In SQL Backup's context, are you running multiple backups or restores simultaneously?
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 1 guest