Forum Discussion

MaheshShinde's avatar
MaheshShinde
Copper Contributor
Aug 26, 2020

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 failure solution for these many number of databases. If you've any solution which would help me please do let me know. 

large number of databases
  • ankit1001's avatar
    ankit1001
    Copper Contributor
    Aug 27, 2020
    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

Resources