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


MS Sql Server LazyDBA home page