Home Forums SQL Server 2008 SQL Server 2008 Administration How many databases on one single instance RE: How many databases on one single instance

  • January 10, 2012 at 3:55 am

    #1430974

    Theoretically, you could have 32,767 databases per instance.

    Good luck with that. . . Personally, I find it difficult to keep track of more than 10.

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/