|
Home > Archive > MS SQL Server Replication > September 2005 > Log Shipping issue
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Log Shipping issue
|
|
| Jamil Ahsan 2005-09-19, 1:25 pm |
| 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
| |
| Steve Chapman 2005-09-26, 11:23 am |
| 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
>
|
|
|
|
|