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?
    thanks
    femig, Nov 30, 2004
    #2

  2. mmarovic Active Member

    If you use mssql 2000 you can have two mssql server instances on the same computer.
    mmarovic, Nov 30, 2004
    #2

  3. zvidas New Member

    It is possible even on one mssql 2000 server, but only without "Allow database to assume primary role" option
    zvidas, Jan 26, 2005
    #2

  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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Jan 26, 2005
    #2

  5. zvidas New Member

    For test purpose way not, but as satya mentioned it's not recommended
    zvidas, Jan 27, 2005
    #2

Share This Page