Results 1 to 2 of 2

Thread: 64bit SQL Enterprise and Instance issue...

  1. #1
    Join Date
    Mar 2003
    Posts
    383

    64bit SQL Enterprise and Instance issue...

    We have an STD SQL 2k machine which has mounted around 900 databases already. And the limitation is 1024 databases.

    according to BOL, "each instance of the SQL server database engine has its own set of system and user databases that not shared between instances.

    questions:
    1. Does it mean with one default instance and 2 named instances, we could 'break' the 1024 databases limitation to 1024 * 3 = 3072?

    2. Does it mean if we upgrade to SQL 2000 32 enterprise or 64 enterprise that would increase the # of databases of 1024 to ...ex 2000?

    thanks
    David

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •