Post reply

mirroring database limits

  • November 22, 2014 at 12:39 am

    #397672

    Hello team,

    Request your help. I have multiple SQL 2008 severs with databases. Also, 1 mirroring server in place.

    Since my database count is increasing can i have only 1 mirroring server. Is there any limit of db at mirroring server. I would have approx. 150 databases.

    Can u please share some thoughts.

  • December 2, 2014 at 8:29 am

    #1762108

    Dear all - any inputs on below.

  • December 3, 2014 at 6:13 am

    #1762337

    for sql server 2008, a principal mirror database can have only one partner.

    You may have multiple principal databases on server A and have one mirrored to server B and another mirrored to server C, that is supported

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 3, 2014 at 11:25 am

    #1762482

    Thanks. In mirroring server are there any limitations on number of databases from principal server?

  • December 3, 2014 at 7:37 pm

    #1762565

    prem-438426 (12/3/2014)

    Thanks. In mirroring server are there any limitations on number of databases from principal server?

    yes there are limits - 32 bit installations can only mirror up to 10 databases - for more info have a look at http://msdn.microsoft.com/en-AU/library/ms366349(v=sql.100).aspx

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

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