SQL Server Performance

Log Shipping Monitor

Discussion in 'SQL Server Log Shipping' started by archit, Jun 28, 2007.

  1. archit New Member

    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
  2. Deepak Rangarajan New Member

    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
  3. MohammedU New Member

    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.
  4. archit New Member

    Thanks...
  5. archit New Member

    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?
  6. satya Moderator

    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.
  7. archit New Member

    ok thanks...

Share This Page