Discussion in 'SQL Server Log Shipping' started by femig, Nov 30, 2004.
is it possible to implement log shipping on the same server as a test?
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.
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
Separate names with a comma.