SQL Server Performance Forum – Threads Archive
Error 14421Hi all,
I’m getting the following error below from my secondary server and the only process that fails intermitently so far is the copy process on the secondary. I need help please Executed as user: DomainSQL Service Acct. The log shipping destination SERVERNAME.DATABASENAME is out of sync by 990 minutes. [SQLSTATE 42000] (Error 14421) Associated statement is not prepared [SQLSTATE HY007] (Error 0). The step failed.
Hi, Are the backups getting copied to the secondary server. Check this physically since the copy job for log shipping will show success even if 0 files are copied. If the backups are getting copied then check the restore jobs.
Best Regards, Chetan Jain
Given the error number, either the restore or the copy process is failing (and you mentioned that the copy process fails intermitently. As Jain mentioned, check that the backups are getting copied. If they’re not getting copied, make sure that the account DomainSQL Server Acct has write permissions to the copy share location. Generally log shipping is pretty easy to troubleshoot. Any one of three things can go wrong, the backup process isn’t working, the copy process isn’t working and/or the restore process isn’t working. Once you’ve figured out what’s broken it’s just a matter of fixing the problem. Also, check the error log to see if there are any restore log errors. Karl Grambow www.sqldbcontrol.com