Red Gate forums :: View topic - Job FailSQL error code: 4208 [SQLSTATE 42000] (Error 50000)
Return to www.red-gate.com RSS Feed Available

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

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

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
nlytle



Joined: 11 Oct 2010
Posts: 2
Location: Clearwater, FL

PostPosted: Mon Oct 11, 2010 10:00 pm    Post subject: Job FailSQL error code: 4208 [SQLSTATE 42000] (Error 50000) Reply with quote

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
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 925
Location: Red Gate Software

PostPosted: Tue Oct 12, 2010 10:51 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
nlytle



Joined: 11 Oct 2010
Posts: 2
Location: Clearwater, FL

PostPosted: Tue Oct 12, 2010 12:24 pm    Post subject: Job FailSQL error code: 4208 [SQLSTATE 42000] (Error 50000) Reply with quote

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
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