SQL Server Performance

Will restore all jobs from failed server?

Discussion in 'SQL Server 2005 Database Mirroring' started by kumaravel v, Feb 24, 2009.

  1. kumaravel v New Member

    I have a mirroring setup in our production servers. I have a question, will the mirrored server start collection jobs when a fail-over occurs from
    failed server ?
    - kmr
  2. arunyadav Member

    In database mirroring, the only thing mirrored is the database, so any other component -- such as logins, SQL Server Integration Services (SSIS) packages, SQL Agent Jobs, etc -- are not automatically mirrored. These items need to be handled outside the process.
  3. kumaravel v New Member

    thanks arun.

Share This Page