Max. number of databases

Hello,
anybody knows what's the maximum number of databases i can create on a SQL
Server 2000 instance?
thanks.
AndresLook in the BOL under 'SQL Server Architecture' -> 'Implementation
Details' -> 'Maximum Capacity Specifications' It's documented as 32,767.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"andsilva" <andsilva@.hotmail.com> wrote in message
news:OEqcrb8gDHA.3784@.tk2msftngp13.phx.gbl...
> Hello,
> anybody knows what's the maximum number of databases i can create on a SQL
> Server 2000 instance?
> thanks.
>
> Andres
>|||Hi Andres,
This is documented in Books Online, under "Maximum Capacity Specifications" article
Maximum number of databases per server instance is 32767
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights. Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
--
| From: "andsilva" <andsilva@.hotmail.com>
| Subject: Max. number of databases
| Date: Thu, 25 Sep 2003 19:37:57 -0500
| Lines: 11
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <OEqcrb8gDHA.3784@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 64.76.52.225
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:308434
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hello,
|
| anybody knows what's the maximum number of databases i can create on a SQL
| Server 2000 instance?
|
| thanks.
|
|
| Andres
|
|
||||In theory 32,767. Practically, you probably want to test thoroughly perf, maint etc if you go above
about 100.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"andsilva" <andsilva@.hotmail.com> wrote in message news:OEqcrb8gDHA.3784@.tk2msftngp13.phx.gbl...
> Hello,
> anybody knows what's the maximum number of databases i can create on a SQL
> Server 2000 instance?
> thanks.
>
> Andres
>