Thursday, March 22, 2012

Database mirroring

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

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

More info :

Database Mirroring in SQL Server 2005.

Thanks.

Naras.

|||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.

No comments:

Post a Comment