Red Gate forums :: View topic - SQLBackup Issue - Service
Return to www.red-gate.com RSS Feed Available

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

SQLBackup Issue - Service

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Kendall359x



Joined: 02 Apr 2013
Posts: 7

PostPosted: Tue Apr 02, 2013 4:54 pm    Post subject: SQLBackup Issue - Service Reply with quote

Hi Guys, We are having a few issues with our log shipping routine using red gate.

We have a server that is log shipping 342 database every 30 mins. We find sometimes that the log backup is getting stuck and hangs until we restart the SQL backup service.

We also get an issue with the DR server restoring the logs and again the service freezes.

Can you offer any assistance in resolving this?

Thank you
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2276

PostPosted: Wed Apr 03, 2013 5:22 am    Post subject: Reply with quote

When SQL Backup encounters a critical error and hangs, it generates a stack trace of events leading up to the error. This stack trace is then stored in a file named SQBCoreService_<instance name>_bugreport.txt, and is located in 'C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\' on Windows 2003 and older, and 'C:\ProgramData\Red Gate\SQL Backup\Log\' on Windows Vista and newer.

Could you check if this file exists on your backup server, and also on the DR server? If they do, could you please send me the files (peter.yeoh@red-gate.com), and also the backup and restore commands you are using?

Thanks.
_________________
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
Kendall359x



Joined: 02 Apr 2013
Posts: 7

PostPosted: Tue Apr 09, 2013 11:13 am    Post subject: Reply with quote

Hi Peter, on a server in question that frozen this morning there is no log file?

However I have one from a different server that also froze this morning but its dated 27/05/2010

Do you still want it?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2276

PostPosted: Wed Apr 10, 2013 3:03 am    Post subject: Reply with quote

I received the files you sent. It looks like you are using an older version of SQL Backup (6.2.0.134). The issue you are encountering could have been fixed in a new version of SQL Backup. Could you please try using version 6.5.0.23, which you can download using this URL:

ftp://support.red-gate.com/patches/sql_backup/SQB_6_5_2_23.zip

The zip file contains two files:

SQBCoreService.exe
SQLBackupC.exe

To apply the patch, please follow the steps below:

1. Close all GUI connections to the SQL Server.
2. Ensure that no SQL Backup jobs are in progress.
3. Stop the SQL Backup Agent Service, or disable the cluster resource if on a cluster.
4. On the SQL Server where the SQL Backup server components are installed, navigate to the installation directory. Defaults are:

32-bit Machines - C:\Program Files\Red Gate\SQL Backup 6\(local) or <SQL Instance Name>
64-bit Machines - C:\Program Files (x86)\Red Gate\SQL Backup 6\(local) or <SQL Instance Name>

5. In the folder you will find an existing SQBCoreService.exe and SQL BackupC.exe. Rename the existing files, for example to OLDSQBCoreService.exe and OLDSQLBackupC.exe.
6. Now copy in the files extracted from the downloaded zip.
7. Restart the SQL Backup agent service/cluster resource, and ensure that it starts successfully.
8. Perform a test backup to ensure that all is OK.
_________________
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
Kendall359x



Joined: 02 Apr 2013
Posts: 7

PostPosted: Mon Apr 15, 2013 9:14 am    Post subject: Reply with quote

This has been applied I will keep you posted.

I had upgraded from the older version already since my post start however I was running 6.5.1.9 not 6.5.2.23.

I will inform you if we experience any further freezing.

Is there a change log for 6.5.2.23?

Thank you
Back to top
View user's profile Send private message
Kendall359x



Joined: 02 Apr 2013
Posts: 7

PostPosted: Thu May 09, 2013 9:06 am    Post subject: Reply with quote

Hello,

This has improve the reliablilty a treat but the issue we have now is that every so often the sql job stops and we get a 2KB transaction log generated with no LSN details. When this is transfered it stops log shipping for the database in question.

Can you assist further?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2276

PostPosted: Mon May 13, 2013 3:22 am    Post subject: Reply with quote

Could you please check if SQL Backup generated a stack trace file when the job failed, as described in my first post in this thread? If so, could you please send me that file, and also the 2 Kb trx log backup file that's generated?

Thanks.
_________________
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
Kendall359x



Joined: 02 Apr 2013
Posts: 7

PostPosted: Mon May 13, 2013 1:24 pm    Post subject: Reply with quote

E-Mail sent.

the stack trace attached file is from the DR server. Red gate has not generated a error file on the server where the 2KB file has been produced.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2276

PostPosted: Mon May 13, 2013 4:06 pm    Post subject: Reply with quote

Could you please send me the SQL Backup log file for the backup that generated the 2 Kb file? The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name> on Windows 2003 and older, and C:\ProgramData\Red Gate\SQL Backup\Log\<instance name> on Windows Vista and newer.

Thanks.
_________________
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
Kendall359x



Joined: 02 Apr 2013
Posts: 7

PostPosted: Wed May 22, 2013 1:22 pm    Post subject: Reply with quote

I have emailed yourself with a link to the logs as there quite large.

Thank you
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2276

PostPosted: Wed May 22, 2013 4:14 pm    Post subject: Reply with quote

I need to see the SQL Backup log file for the backup that failed, which appears to have happened on May 13, 2013 11:05. You sent me 76000+ files, none of which are for May 13. Could you please just send me the log files that were created on May 13, 2013, between 11:00 am and 11:30 am?

Thanks.
_________________
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
Kendall359x



Joined: 02 Apr 2013
Posts: 7

PostPosted: Fri May 24, 2013 8:31 am    Post subject: Reply with quote

We don't keep logs that old.

I will wait until the next failure and then send you the logs, we keep getting it about 3 or 4 times a day so it wont be long.
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