Home Forums Database Design Disaster Recovery How to sync linked server, jobs, alerts, logins, etc to a secondary serveur RE: How to sync linked server, jobs, alerts, logins, etc to a secondary serveur

  • If you don't mind using SSIS - You can also use the transfer jobs, transfer logins, transfer SQL objects, and transfer master stored procedures tasks in SSIS to keep the 2 servers in sync

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience