Red Gate forums :: View topic - SQL error 701, 3271, 3013, Error Code: -2139684860
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

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

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
michaeldye



Joined: 03 Apr 2007
Posts: 1

PostPosted: Wed Jul 04, 2012 8:03 am    Post subject: SQL error 701, 3271, 3013, Error Code: -2139684860 Reply with quote

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.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2299

PostPosted: Wed Jul 04, 2012 9:46 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group