Job FailSQL error code: 4208 [SQLSTATE 42000] (Error 50000)

Forum for users of Red Gate SQL Backup tool

Moderator: Chris Auckland

Job FailSQL error code: 4208 [SQLSTATE 42000] (Error 50000)

Postby nlytle » Mon Oct 11, 2010 10:00 pm

Our log shipping job is failing and the step is always failing with this error:
SQL Backup failed with exit code: 1010 SQL error code: 4208 [SQLSTATE 42000] (Error 50000). The step failed.

Anyone have any ideas what this is, and how I can get the log shipping running again?

Thanks,
Nancy
nlytle
 
Posts: 2
Joined: Mon Oct 11, 2010 9:51 pm
Location: Clearwater, FL

Postby eddie davis » Tue Oct 12, 2010 10:51 am

Hi, thank you for your post into the forum.

How strange, SQL Error 4208 indicates that a log backup has been called but the database is using the SIMPLE recovery model, as per this MSDN article: http://msdn.microsoft.com/en-us/library/aa226364(SQL.80).aspx

However you can only set up log shipping if the source database is using the FULL recovery model.

Are you performing any maintenance tasks, for example index re-builds, where the database recovery model is being modified from FULL to SIMPLE. The index re-build takes place and on completion, the recovery model is switched back to using the FULL recovery model?

If the answer is yes, please consider modifing the job so that the database recovery model is switched from FULL to BULK-LOGGED, perform the maintenance task and then switch back to the FULL recovery model.

The above action action will prevent SQL Error 4208 from occurring and prevent a break in the transaction log backup chain.

I hope the above helps.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Job FailSQL error code: 4208 [SQLSTATE 42000] (Error 50000)

Postby nlytle » Tue Oct 12, 2010 12:24 pm

I had set the recovery model to Full and still the job failed with the same error message. Is there anything special I need to do to get the log shipping going again?
Now our full backups have failed with the error: SQL Backup job failed with exitcode: 161 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed.

Nancy
nlytle
 
Posts: 2
Joined: Mon Oct 11, 2010 9:51 pm
Location: Clearwater, FL


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests