SQL Server Performance

log shipping

Discussion in 'SQL Server Log Shipping' started by bfarr23, May 25, 2005.

  1. bfarr23 New Member

    can i log ship from sql server 2000 ENT to sql server 2000 STD?
  2. zvidas New Member

  3. satya Moderator

    It should work as the BACKUP/RESTORE statement has no changes between Standard and Enterprise. In this case EE as primary and SE as secondary will do the rest.

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

    in BOL it says need both to be ENT editions.
  5. bfarr23 New Member

    anyone have this working with EE and SE?
  6. satya Moderator

    True and you can use log shipping in standard edition using Microsoft BackOffice Resource Kit (BORK) 4.5.

    We have our own log shipping pattern code between EE and SE... working like a charm, I never trust wizards generated from Enterprise Manager.

    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.

Share This Page