• How many databases you can mirror on a single server relies on many factors such as workload, the number of CPUs, the capabilities of the server. You need to test it with a production workload to see how many databases are feasible with your environment.

    You will not lose data during a network outage unless you lose the principal database. All of the transactions not yet mirrored will be preserved in the log file until mirroring reconnects and the transactions are transferred to the mirror.

    I highly recommend you get a copy of my book. You can download the ebook version directly from the publisher.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]