SQL Server Performance

Log Shipping on SQL Server 2000 Standard Edition

Discussion in 'SQL Server Log Shipping' started by sukumar, Apr 14, 2005.

  1. sukumar New Member

    Hi,

    We need to implement Log Shipping on SQL Server 2000 Standard Edition. I have heard that there are some undocumented stored procedures that can be used for Log Shipping in Standard Edition but I haven't got it as complete information as it is there on Enterprise Edition.

    Could someone please help us by directing to some specific piece of information that guides through implementing Log Shipping on SQL Server 2000 Standard Edition?

    Regards,
    Sunil Bansal
  2. satya Moderator

    There aren't any undocumented stored procedure for log shipping and Enterprise Manager's log shipping utility is available only for the SQL Server 2000 Enterprise Edition and SQL Server 2000 Developer Edition.

    For the Standard Edition is the Simple Log Shipper tool, which you can find in the Microsoft SQL Server 2000 Resource Kit. Simple Log Shipper uses a linked-server relationship between the primary server and the secondary server.


    Search on this site for BRad's explanation on performing own log shipping.


    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. kirschi New Member

    Hi satya,

    can you or anyone else tell me, what the drawbacks are when using the simple log shipping tool in SQL Standard Edition?

    Thanks,
    Daniel
  4. satya Moderator

    There are no drawbacks in using pre-defined log shipping, you will in more grip to handle any issues in the transaction log restore. The tool from Resource Kit is similar to the Enterprise Edition's log shipping wizard, so no issues as such.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. chinni1978 New Member

    could anyone plz post the link of the simple log shipping tool.Because i am unable to find that in anywhere..
    Plz post it in urgent basis.
  6. satya Moderator

  7. chinni1978 New Member

    thanx satya..
    could you please post the tool of simple logshipping if you have.
  8. satya Moderator

    No such tool, you have to design based on the links given above.

Share This Page