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

  • I've actually never had an issue with the SSIS task, from my perspective it works perfectly. What kinds of issues have you encountered sqlBuddy?

    I set up the task:

    LoginsToTransfer = SelectedLogins

    LoginList = (Collection)

    IfObjectExists = Skip

    CopySids = True

    Works like a charm. Albeit, I've never tested the accounts further than connecting to the DB and running a simple SELECT query, but it did work.

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