Can someone explain what is the best method to backup a publisher server ? Currently I use a spare server that I restore monthly and this server is not connected to the production network, so when publisher server fails, I move the LAN cable to the spare server, and the connection can be directly resolved. I use the same name, and same IP as the publisher server to the spare server
But when I simulate this method, everything works except the replication between subscribers and the spare server. The replication fails because the subscribers are not registered to the spare server. Is this a matter of time ? Anyone expert in SQL explain about this ? Or is there any other method for recovery ?