Hello, I am trying to set up new log shipping on Sql Server 2000 to another instance of the same on my laptop. But it says that the Log Shipping Monitor allready exists. I have allready removed the previous log shipping which was configured. and following through the wizard of log shipping there is no way I can skip the step or configuring the new log shipping monitor, either the primary or secondary. How to remove this log shipping monitor? Thanks, archit
Hi, • log_shipping_plans • log_shipping_plan_databases • log_shipping_databases • log_shipping_plan_history • log_shipping_monitor • log_shipping_primaries • log_shipping_secondaries These are the systewm tables available in msdb,if u had configured log shipping earlier. check log_shipping_monitor system table since u had already configured log shipping there was already an entry in these system tables,so u just need to remove those records....it shud be fine have a nice day Regards Deepak SQL DBA
Use the following article to remove log shipping... http://support.microsoft.com/kb/298743 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): 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): To delete the log shipping plan. • sp_delete_log_shipping_secondary 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): To delete the log shipping monitor information from the log_shipping_monitor table. MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
I have got a database on sql2005 instance. I took a full backup of it and did not take any transactional log back up. Then I tried restoring that backup with "standy by/read only" option. now I can not access it even to restore with recovery mode.. what shall I do?
Why don't you start a new thread as this is not related to Log shipping? Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
