February 10, 2006 at 4:00 am
Hi 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: Domain\SQL 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.
Any help much appreciated
Matey
February 10, 2006 at 8:27 am
I think , your database log file is not shipped to the server.
Properly.
February 14, 2006 at 3:52 pm
check the SQL Agent is running and verify the restore jobs on destination and if it missed to ship the log then try to manually restore the log files.
thx,
krishnan kaniappan
-Krishnan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply