Ask SQLTeam Question
Posted - 03/05/2007 : 10:43:17
| Anna writes "Hi All,
I have set up logshipping between two servers. The transactional log backups are set to run evey 10 minutes. The problem is that, the Transaction Log Backup job on the primary server keeps failing at certain times, for instance every 30 minutes (it runs fine at the 10th, 20th, 40th minutes etc, but just fails every 30th minute eg it fails at 7:30, 8:00, 8:30 etc) it is totally random. If I configure logshipping again, it fails at another interval.
I do not have another transactional log backup set-up on that server nor do I have DTSs that copy objects from this server to another (I learnt that these could interrupt transaction backups).
I'm not sure what is still causing the backup to fail at certain times. Following, please find the error on the event log:
Category: Job Engine
Event ID: 208
SQL Server Version: 2000, SP3
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'LogShipping_Timesheeting'' (0xD66AD2C1F7537C409C34CC6DB263D5CF) - Status: Failed - Invoked on: 2007-02-28 08:00:03 - Message: The job failed. The Job was invoked by Schedule 80 (Schedule 1). The last step to run was step 1 (Step 1).
I have reconfigured log shipping several times, but it still keeps failing at random intervals and hence doesnt seem stable to me. Could transactional locking cause such problems? Am I missing anything? What can I do to prevent it from happening?
Any advice would be appreciated.