SQL Server with Large number of databases

%3CLINGO-SUB%20id%3D%22lingo-sub-1612534%22%20slang%3D%22en-US%22%3ESQL%20Server%20with%20Large%20number%20of%20databases%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612534%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20know%20any%20solution%20to%20handle%20large%20number%20of%20databases%20on%20single%20SQL%20instance%3F%3C%2FP%3E%3CP%3EI%20have%20SQL%20server%20with%2025000%20databases.%20It%20is%20very%20much%20challenging%20to%20implement%20DR%20and%20single%20point%20of%20failure%20solution%20for%20these%20many%20number%20of%20databases.%20If%20you've%20any%20solution%20which%20would%20help%20me%20please%20do%20let%20me%20know.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1612534%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Elarge%20number%20of%20databases%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1615232%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20Server%20with%20Large%20number%20of%20databases%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1615232%22%20slang%3D%22en-US%22%3EHi%20%2C%3CBR%20%2F%3EYou%20can%20go%20for%20Always%20on%20Availability%20Groups%20solution%20where%20your%20databases%20can%20be%20brought%20under%20multiple%20AAG%20groups%2Cthus%20having%20multiple%20listeners.%20You%20can%20bring%20related%20databases%20in%20these%20AAG%20groups.%20With%20Automatic%20fail-over%20the%20databases%20will%20allways%20be%20available%20and%20you%20do%20not%20need%20licence%20of%20SQL%20server%20for%20DR%20site.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3EAnkit%20Tandon%3C%2FLINGO-BODY%3E
Visitor

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. 

1 Reply
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