You just need to clean out the msdb..log_shipping_* tables on both primary
and secondary servers.. Find that server name and just delete those rows.
Back it up first, if this makes you nervous. Also double check the
sysdbmaint* tables. The stored procs are supposed to do this, but you know
how that goes sometimes.



-- chip

-----Original Message-----
From: KScherer
[mailto:mssqldba-ezmlmshield-x41651438.[Email address protected]
Sent: Friday, July 29, 2005 9:01 AM
To: LazyDBA Discussion
Subject: Log shipping error message

Hello All:



The problem I'm having is two-folded:



I was having trouble re-creating a log shipping job in SQL using the
database maintenance plan wizard.... I deleted a database and then recreate
it (when I deleted the database, it deleted all maintenance plans and jobs
associated with it). When I went back in to create the maintenance job
(with log shipping), it doesn't gray-out the "Ship the transaction logs to
other SQL Servers (log shipping) (which it does if a job already exists for
log shipping)...



Everything goes good until I get to the end of the wizard and I click
Finish. Then I get this error message:



error 14261: The specified primary_server_name.primary_database_name
("M") already exists.



The other time it didn't work was after I went in and deleted the
maintenance plan from the "Database Maintenance Plans" console. It seemed
to delete all jobs associated with the maintenance plan... But then, when I
went back in to re-create the plan, the log shipping checkbox is grayed
out...



I tried this:



After you run the Maintenance Wizard and it fails to create the Log Shipping
setup, you must manually clean up the tables before you run the wizard
again. Depending on where the failure is, you must run some of the stored
procedures to delete the entry.



You may have to run the following stored procedures to clean up log shipping
entries and allow the wizard to be re-run:

*

sp_delete_log_shipping_primary
<http://msdn.microsoft.com/library/psdk/sql/ts_sp_da-di_1pnt.htm>
(http://msdn.microsoft.com/library/psdk/sql/ts_sp_da-di_1pnt.htm): To delete
the primary server from the log_shipping_primary table.

*

sp_delete_log_shipping_plan
<http://msdn.microsoft.com/library/psdk/sql/ts_sp_da-di_7o6h.htm>
(http://msdn.microsoft.com/library/psdk/sql/ts_sp_da-di_7o6h.htm): To delete
the log shipping plan.

*

sp_delete_log_shipping_secondary
<http://msdn.microsoft.com/library/psdk/sql/ts_sp_da-di_77s9.htm>
(http://msdn.microsoft.com/library/psdk/sql/ts_sp_da-di_77s9.htm): To remove
secondary server from log_shipping_secondaries table.

*

sp_remove_log_shipping_monitor
<http://msdn.microsoft.com/library/psdk/sql/ts_sp_ra-rz_0cyx.htm>
(http://msdn.microsoft.com/library/psdk/sql/ts_sp_ra-rz_0cyx.htm): To delete
the log shipping monitor information from the log_shipping_monitor table.



Still no success! Any help would be greatly appreciated!



Karin



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page