Comments
6 comments
-
Could you pls run a test backup manually, and post any error message you encounter here e.g.
EXEC master..sqlbackup '-sql "BACKUP DATABASE model TO DISK = [c:\model.sqb] WITH INIT" '
-
I ran backup manually as requested. It worked. Below is output; however, I still cannot connect using the GUI running on the server. I get the following error from the gui:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Backing up model (full database) on PASCRSQLPROD01 instance to:
c:\model.sqb
Database size : 1.875 MB
Compressed data size: 54.500 KB
Compression rate : 97.16%
Processed 80 pages for database 'model', file 'modeldev' on file 1.
Processed 1 pages for database 'model', file 'modellog' on file 1.
BACKUP DATABASE successfully processed 81 pages in 0.063 seconds (10.418 MB/sec).
SQL Backup process ended. -
Hi there,
If this is a genuine timeout due to a slow or busy server, you may be able to mitigate the situation by changing the default timeouts for that server. If you edit the server's connection properties and go to the second tab, you can change the timeouts there.
Adjusting them down is not necessarily a good plan, as it can lead to failures purely due to low values. But adjusting them up for cases where timeouts are occurring is certainly worth a go.
I hope this helps,
All the best,
Dan
Dan J Archer
Red Gate Software -
We purchased 10 licenses for Red-Gate Backup and are receiving this same error on one of our servers. The GUI reports "Error opening mutex." and the service on the server simply sits on starting. Trying to start the service from the service manager reports an error "Error 1053: the Service did not respond in a timely fashion" The service stays on Starting status until you go to Task Manager and end task SQBCoreService.exe.
This is one of our main servers so we would like to get it running on our Red-Gate backup strategy as soon as possible.
Are there any log files I can look at, there are no errors in the event log from SQL Backup.
Thanks -
I've sent you a private message on how to enable logging for the SQL Backup Agent service. Try that and send me the resulting log. Thanks.
-
JRussells' issue has been addressed. The SQL Backup Agent service failed to start because it was not started with the -I parameter for the SQL Server named instance it was serving.
Add comment
Please sign in to leave a comment.
If I switch the SQL Backup service account to be an administrator account, the service will start but I cannot connect using the SQL Backup GUI. When attempting to connect I get error acquiring mutex.