Hi All,
I am a new learner of SQL2000. Recently I learned to setup log shipping.
I have Primary Server (A) and 1st Secondary Server (B) at my head office.
I also have 2nd Secondary (C) at a remote site. Server A log ship logs to
server B and C. Server C is my monitor server also. One of the log shipping
failed. Now when I try to re- establish log shipping I am getting following
error:
"Error 14261: he specified primary_server-name.primary-database-name('F')
already exist."
I don't see any thing in log shipping monitor nor under Databasse
maintenance Plans. Please guide me how to get rid of error.
Many Thanks,
Jamil
If you look in the msdb database on your sql server there are a series of
tables starting "Log Shipping" .. they should all be empty before you set up
your plan. This applies to all 3 servers, dont forget to clear the tables on
the monitor server.
"Jamil Ahsan" wrote:
> Hi All,
> I am a new learner of SQL2000. Recently I learned to setup log shipping.
> I have Primary Server (A) and 1st Secondary Server (B) at my head office.
> I also have 2nd Secondary (C) at a remote site. Server A log ship logs to
> server B and C. Server C is my monitor server also. One of the log shipping
> failed. Now when I try to re- establish log shipping I am getting following
> error:
> "Error 14261: he specified primary_server-name.primary-database-name('F')
> already exist."
> I don't see any thing in log shipping monitor nor under Databasse
> maintenance Plans. Please guide me how to get rid of error.
> Many Thanks,
> Jamil
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment