SQL Server Performance

log shipping test on the same server

Discussion in 'SQL Server Log Shipping' started by femig, Nov 30, 2004.

  1. femig New Member

    is it possible to implement log shipping on the same server as a test?
  2. mmarovic Active Member

    If you use mssql 2000 you can have two mssql server instances on the same computer.
  3. zvidas New Member

    It is possible even on one mssql 2000 server, but only without "Allow database to assume primary role" option
  4. satya Moderator

    The log shipping pair should never exist on the same server. Even though this is possible due to the multiple instances support of SQL Server 2000, the reason for not having them on the same box is that the server becomes a single point of failure.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. zvidas New Member

    For test purpose way not, but as satya mentioned it's not recommended

Share This Page