Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: SQL SERVER 2005 Database Mirroring for large number of databases

    I am trying to enable database mirroring for 100 database.
    It goes error free till 59 databases (some times 60 databases) with the
    status (principal, synchronized) on principal. on the 60th or 61st database
    it gave the status (principal, disconnected). Also mirror starts acting
    abnormal. connection to mirror starts to give connection timeout and it is
    not enabling database mirroring on any more databases. I have SQL SERVER
    2005 Enterprise with SP1 on the servers. witness is not included yet.

    this are my test servers... i have more than 500 databases on my production

    principal and mirror both are using port 5022 for ENDPOINT communication.

  2. #2
    Join Date
    Nov 2003


    System has 3 GB of RAM, SQL SERVER (Mirror) using 85 MB of RAM but still giving this error while trying to enable database mirroring for 37th Database.....

    "There is insufficient system Memory to run this query"


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts