locked
Database mirroring RRS feed

  • Question

  • Hi All

             I need to find out on limitation in SQL 2005 standered edition on numbers of databases can be mirrored, in other words whats the maximum numbers of databases can be used for database mirroring

     

    Thanks

    Alps

     

    Wednesday, May 23, 2007 5:42 PM

Answers

  • As explained there is not such limit, but on 1 server it is not advisable to have more than 10 database that is based on the tests performed on a high-end spec. hardware. Also when it comes to recover in case of any recovery it will take more time to recover and in this case based on your requirement you might look at to restrict upto 5 database per instance.
    Monday, May 28, 2007 4:02 PM

All replies

  • I believe that there is no limitation on using databases in database mirroring.

    More info :

    Database Mirroring in SQL Server 2005.

     

    Thanks.

    Naras.

     

    Thursday, May 24, 2007 5:39 AM
  • As explained there is not such limit, but on 1 server it is not advisable to have more than 10 database that is based on the tests performed on a high-end spec. hardware. Also when it comes to recover in case of any recovery it will take more time to recover and in this case based on your requirement you might look at to restrict upto 5 database per instance.
    Monday, May 28, 2007 4:02 PM