Home Forums SQL Server 2008 SQL Server 2008 Administration mirroing - Restoring RE: mirroing - Restoring

  • October 25, 2012 at 8:38 am

    #1552738

    Perry Whittle (10/25/2012)

    arkiboys (10/25/2012)

    GilaMonster (10/25/2012)

    SQL Agent jobs are not included in mirroring, mirroring is just the DB you configure, jobs are in MSDB. If you want them, you have to transfer them.

    How can the sql server jobs appear in the mdr machine?

    I mean how can they be copied so that I see them as I do in the prod management studio in sql server?

    Thanks

    script the jobs out and copy them same as the logins too.

    Either that or use an SSIS package task to transfer the objects for you 😉

    I can script the job in production.

    In the script, I see the name for the production server.

    On running this script in the mdr (mirrored server), do I change the production server name to the mirrored server name?