Post reply

system databases mirroring

  • November 20, 2012 at 1:05 am

    #270412

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

    Thanks

  • November 20, 2012 at 1:55 am

    #1560644

    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

  • November 21, 2012 at 11:26 am

    #1561340

    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?

  • November 21, 2012 at 11:31 am

    #1561344

    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