SQL Server Performance

Transfer system objects

Discussion in 'SQL Server 2005 Database Mirroring' started by jn4u, Oct 25, 2007.

  1. jn4u Member

    Hi
    I’m in theplanning stage for Mirror or log shipping solution for a database. The problemis how to copy “System Objects” as Logins, Linked Server, SSIS, Agent Jobs, xpsand assemblies, etc. Today I’m doing it with scripts and manually. Thinking ofusing SSIS tasks or what is your opinion the best solution?
    How do transfer the replications settings to secondary server....
    jn4u, Oct 25, 2007
    #2

  2. satya Moderator

    How many jobs and packages you are talking here?
    Only way I can think of is manually, if you have scripts for packages thenyou can recreated them on the standby server.
    satya, Oct 25, 2007
    #3

Share This Page