Post reply

Number of database

  • September 6, 2006 at 12:57 am

    #119440

    Hi, with SQL Server 2000 or SQL Server 2005 what is the maximum number of database I can create ?

    Thanks

  • September 6, 2006 at 7:04 am

    #658724

    Pretty much unlimitted (32,767 is the limit per server but I've never seen anyone need that).

  • September 7, 2006 at 10:10 am

    #659149

    According to the while paper, 32767 is the max for SQL2000.

    But the limitation was around 1100 to 1200 in my working environment. We have failed 2-3 times when the # of databases on a SQL2000 enterprise server reached around 1200. Thus, We have spreaded 3800 databases into 4 servers already. A testing of loading to SQL2005 proves the improvement: 3500. But loading itself is differnt from running.....

     

     

  • September 7, 2006 at 10:45 am

    #659156

    How many databases do you need to implemant???

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply