Monday, March 19, 2012

how many databases can be set up in one Sql server instance

I am using sqlserver to its limitation ,So I am concerning how many
databases can be created in one Sql server instance. Anyboday know
this issue ? I am grateful for your answer>I am using sqlserver to its limitation, So I am concerning how many
> databases can be created in one Sql server instance. Anyboday know
> this issue? I am grateful for your answer
Databases per instance of SQL Server: 32,767
SQL Server 2005 Books Online > Maximum Capacity Specifications:
http://msdn2.microsoft.com/en-us/library/ms143432.aspx
Tom
http://kbupdate.info/ | http://suppline.com/|||I have a client with 6287 databases on a pretty small box and it works fine.
Note that most third party tools roll over and die when you try them against
such a server.
TheSQLGuru
President
Indicium Resources, Inc.
"csonnet" <haiming.chen@.gmail.com> wrote in message
news:1182844134.925881.299380@.o11g2000prd.googlegroups.com...
>I am using sqlserver to its limitation ,So I am concerning how many
> databases can be created in one Sql server instance. Anyboday know
> this issue ? I am grateful for your answer
>

No comments:

Post a Comment