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

  • alexandre.jobin (4/7/2014)


    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?

    SSIS is a pretty good tool when used for ETL tasks\jobs. You can definitely make a good use of it.

    The only issue is with the Transfer Object\Login tasks which doesn't work as expected.

    --

    SQLBuddy