SQLBackup Issue - Service

Compresses, encrypts, secures and monitors SQL Server backups.

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

SQLBackup Issue - Service

Postby Kendall359x » Tue Apr 02, 2013 4:54 pm

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
Kendall359x
 
Posts: 7
Joined: Tue Apr 02, 2013 4:48 pm

Postby petey » Wed Apr 03, 2013 5:22 am

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
petey
 
Posts: 2230
Joined: Sun Apr 24, 2005 12:34 pm

Postby Kendall359x » Tue Apr 09, 2013 11:13 am

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?
Kendall359x
 
Posts: 7
Joined: Tue Apr 02, 2013 4:48 pm

Postby petey » Wed Apr 10, 2013 3:03 am

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_ ... 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
petey
 
Posts: 2230
Joined: Sun Apr 24, 2005 12:34 pm

Postby Kendall359x » Mon Apr 15, 2013 9:14 am

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
Kendall359x
 
Posts: 7
Joined: Tue Apr 02, 2013 4:48 pm

Postby Kendall359x » Thu May 09, 2013 9:06 am

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?
Kendall359x
 
Posts: 7
Joined: Tue Apr 02, 2013 4:48 pm

Postby petey » Mon May 13, 2013 3:22 am

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
petey
 
Posts: 2230
Joined: Sun Apr 24, 2005 12:34 pm

Postby Kendall359x » Mon May 13, 2013 1:24 pm

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.
Kendall359x
 
Posts: 7
Joined: Tue Apr 02, 2013 4:48 pm

Postby petey » Mon May 13, 2013 4:06 pm

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
petey
 
Posts: 2230
Joined: Sun Apr 24, 2005 12:34 pm

Postby Kendall359x » Wed May 22, 2013 1:22 pm

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

Thank you
Kendall359x
 
Posts: 7
Joined: Tue Apr 02, 2013 4:48 pm

Postby petey » Wed May 22, 2013 4:14 pm

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
petey
 
Posts: 2230
Joined: Sun Apr 24, 2005 12:34 pm

Postby Kendall359x » Fri May 24, 2013 8:31 am

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.
Kendall359x
 
Posts: 7
Joined: Tue Apr 02, 2013 4:48 pm


Return to SQL Backup 6

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests

cron