Red Gate forums :: View topic - Log shipping restores requiring constant intervention
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

Log shipping restores requiring constant intervention

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



Joined: 27 Jan 2009
Posts: 7

PostPosted: Wed Aug 01, 2012 4:15 pm    Post subject: Log shipping restores requiring constant intervention Reply with quote

SQL Backup version: 6.5.1.9

Problem: We have roughly 7 databases being log shipped from one server to another. Both are on Windows Server 2003 64 bit and SQL Server 2008 64bit. The logs are backed up to a local share and then copied to a share on the destination server and restored.

This works fine mostly however at least 5-6 times a week one of the restore jobs for a database (different one each time) will run indefinitely and the database will get out of synch. The only solution I have found is to wait until none of the other SQL restore jobs are running, restart the red gate backup service (which will then fail the offending job), and then start the job again which it usually runs fine at that point.

What could be causing this and how can I resolve it?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2299

PostPosted: Thu Aug 02, 2012 8:05 am    Post subject: Reply with quote

Could you please try using the latest patch for the 6.5 release? You can download it using the following URL:

ftp://support.red-gate.com/patches/sql_backup/SQB_6_5_2_21.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
Derekg



Joined: 27 Jan 2009
Posts: 7

PostPosted: Thu Aug 02, 2012 2:46 pm    Post subject: Reply with quote

Actually I thought I was on the latest patch...when I tried "check for updates" in the backup interface it only showed an upgrade to version 7.

With that said I will absolutely apply the update, thanks!
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2299

PostPosted: Thu Aug 02, 2012 3:27 pm    Post subject: Reply with quote

The latest official release for the 6.x series is the 6.5.1 release. Issues discovered in 6.5.1 were patched in the 6.5.2 releases, and also in 7.0.

You can view the issues addressed in 6.5.2 here:

ftp://support.red-gate.com/patches/sql_backup/SQB_6_5_2_patch_history.txt

For your issue, I believe it was addressed in patch 13.
_________________
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
Derekg



Joined: 27 Jan 2009
Posts: 7

PostPosted: Tue Aug 07, 2012 2:22 pm    Post subject: Reply with quote

This seemed to resolve the issue, thanks!
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