March 23, 2014 at 10:04 pm
Hello,
Secondary DB goes into suspect mode after Log shipping restore. while checking error logs found this:
Date3/23/2014 11:45:21 AM
LogSQL Server (Current - 3/23/2014 9:34:00 PM)
Sourcespid146
Message
WARNING: did not see LOP_CKPT_END.
FYI...Primary DB is being mirrored also
Many thanks.
March 23, 2014 at 11:09 pm
Rund the DBCC CHECKDB command to find further information.
Refer following link for the actions to resolve the issue:
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 23, 2014 at 11:43 pm
I was more interested in knowing error of the problem rather recovering
March 24, 2014 at 6:25 pm
any pointers????
March 25, 2014 at 4:57 am
SQLb2t (3/24/2014)
any pointers????
I believe LOP_CKPT_END (LOP=Log Operation, CKPT=CheckPoint) is an entry made by Sql Server to the Transaction Log during a CheckPoint (You can read more about CheckPoints here http://technet.microsoft.com/en-us/library/ms189573.aspx).
As to why you are getting the error, I honestly couldn't say but I suspect that you may be dealing with some kind of corruption.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply