Forum Discussion
SQL Server with Large number of databases
Does anyone know any solution to handle large number of databases on single SQL instance? I have SQL server with 25000 databases. It is very much challenging to implement DR and single point of fail...
Hi ,
You can go for Always on Availability Groups solution where your databases can be brought under multiple AAG groups,thus having multiple listeners. You can bring related databases in these AAG groups. With Automatic fail-over the databases will allways be available and you do not need licence of SQL server for DR site.
Thanks
Ankit Tandon
You can go for Always on Availability Groups solution where your databases can be brought under multiple AAG groups,thus having multiple listeners. You can bring related databases in these AAG groups. With Automatic fail-over the databases will allways be available and you do not need licence of SQL server for DR site.
Thanks
Ankit Tandon
