Red Gate forums :: View topic - Backup stuck in KILLED/ROLLBACK
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

Backup stuck in KILLED/ROLLBACK

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



Joined: 31 May 2011
Posts: 55
Location: Zotec Partners

PostPosted: Mon Feb 18, 2013 4:41 pm    Post subject: Backup stuck in KILLED/ROLLBACK Reply with quote

Do failed backups require rollback?
Are multiple instances of process "SQBCoreService.exe " normal?

One of our production servers was experiencing memory pressure which required intervention. The memory pressure was caused from SQL utilizing 31GB of 32GB when max memory was set to 28GB. (No other memory heavy programs/processes run from this box)

I stopped the sql agent service.
I stopped SQL Backup service. (redgate)
Multiple backups were hung for over 3 hours. 2 FULL backups and 2 LOG backups.
An attempt to kill the proccesses inside SQL resulted in a KILLED/ROLLBACK status for all 4 processes.

Further investigation found multiple instances of process "SQBCoreService.exe "

All other production servers (even during multiple backups) have only 1 instance of process "SQBCoreService.exe "

Do failed backups require rollback?
Are multiple instances of process "SQBCoreService.exe " normal?
Back to top
View user's profile Send private message
epetro



Joined: 31 May 2011
Posts: 55
Location: Zotec Partners

PostPosted: Mon Feb 18, 2013 8:53 pm    Post subject: Discussion with support Reply with quote

I contacted support for this issue and we were unable to rectify the issue. I don't believe the underlying issue was caused by Redgate software. I will be reviewing the cause for the memory 'explosion'.

We have scheduled an emergency server reboot this evening.

I did learn that 1 process =SQBCoreService.exe is expected per SQL instance on the box. We only have a single instance, so 4 was abnormal, but no investigation was possible.

Support also shared this ...unfortunately for my scenario it requires that SQL Backup Agent service be operational.
Code:
Thanks for your call - to try and get the crash-log, do the following:

USE master
GO
EXECUTE master..sqbutility 9997
GO
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Tue Feb 19, 2013 6:56 pm    Post subject: Reply with quote

Thanks for posting back the end result - and I'm glad you're up and running now!
Back to top
View user's profile Send private message
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