We are thinking of incorporating Database Mirroring. Company does not have time/budget for AlwaysOn Availability Groups. We currently conduct 24hr backup/restore from one server to another secondary server in geographical location. We want to reduce 24hr gap. Will utilize Asynchronous High Performance Mode.
We have around 50 databases, that we will move from Principal Server A to Mirror Server B. Does SQL Server have any limitations on number of databases we can incorporate?
Company only consumes 1-2TB a yr, 50 million rows max in table, 200GB memory, 50 Cores on Principles, same with Mirror server