log shipping test on the same server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

log shipping test on the same server

is it possible to implement log shipping on the same server as a test?
thanks
If you use mssql 2000 you can have two mssql server instances on the same computer.
It is possible even on one mssql 2000 server, but only without "Allow database to assume primary role" option
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.
For test purpose way not, but as satya mentioned it’s not recommended
]]>