system databases mirroring

  • On the mirroring server (The server which is mirroring the production server databases), should it also mirror the system databases too?

    Thanks

  • System databases cannot be mirrored, only user databases.

    You probably want to copy over logins, jobs, etc, but it can't be done by mirroring the DBs.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (11/20/2012)


    System databases cannot be mirrored, only user databases.

    You probably want to copy over logins, jobs, etc, but it can't be done by mirroring the DBs.

    How can the logins and jobs be copied to the mirroring machine?

  • Many ways. Try the SSIS transfer logins and transfer jobs tasks.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply