October 3, 2008 at 3:35 am
I have set up Log Shipping using a Primary, Secondary and Monitor server.
All appears to be working fine and I never noticed any problems when setting up the log shipping. The problem I have is when I try to report on the Transaction Log Shipping Status on the Primary Server I get the following error message:
Violation of PRIMARY KEY constraint 'PK__#log_shipping_mo_3F115E1A'. Cannot insert duplicate key in object 'dbo.#log_shipping_monitor'.
The reporting works fine on both the Secondary and the Monitor servers. However saying that the information on the monitor server for the primary is blank which I assume is related to this problem.
I have stopped and restarted the instance since and this has no affect.
Any help is very welcome..
October 8, 2008 at 11:25 am
Something doesn't make sense.
You say you are trying to "report on the Transaction Log Shipping Status on the Primary Server". This leads me to believe you are just doing "select" statements, yes? But the error you mention is related to inserting records. Can you add more details about what you are doing and when you get the error?
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
November 17, 2008 at 6:52 am
yes. the same problem happened with me as well. Even if you are using reporting option only, it tried to insert records in temp table and giving the same error.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply