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

  • sqlbuddy123 (4/4/2014)


    I don't rely on SSIS transfer Object\Login task as it gives lot of issues.

    alright, i will do it manually. Maybe it should be another topic but what kind of issues can you have with SSIS? Are you talking about issues to transfert objects/logins with ssis or the issues is with ssis in general?

    we are planning to use ssis for night jobs. What should i know about ssis? is it time consuming or i can rely on it to be maintenance free?