Log Shipping error

[djj55]

Hello, With SQL 2000 I am getting an error

Error 14261: The specified plan_name ('DB1.MyDB_logshipping') already exists.

One thing that I do not understand is the name I entered was LogShipping_MyDB. This was after I executed

execute msdb..sp_delete_log_shipping_primary 
    @primary_server_name = N'DB1', 
    @primary_database_name = N'MyDB'

execute msdb..sp_delete_log_shipping_plan 
    @plan_name = 'MyDb_logshipping'

execute msdb..sp_delete_log_shipping_plan 
    @plan_name = 'DB1.MyDb_logshipping'

The first said complete the last two said does not exist.

I have created other log shipping today and they seem to be working.

Any ideas?

djj

 

[JayKusch]

Have you looked in the actual log shipping tables in the MSDB database to see if the plan does indeed exist?

Thanks

J. Kusch

 

[djj55]

Thank you for the reply.

I did look into any table that started 'log' or had 'plan' in the name.

Nothing out of line, and no MyDB.

So after getting your reply, I looked on the destination server and found it there (log_shipping plans).


Thank you,
djj

 

[JayKusch]

Great!

Thanks

J. Kusch