Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How many Database can be created in a MSSQL 2008 Expand / Collapse
Author
Message
Posted Tuesday, February 26, 2013 10:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 6, 2014 11:47 PM
Points: 4, Visits: 7
How many Database can be created in a MSSQL 2008 R2. Can any one give me the exact number with an explanation.

Does the DB number will differ according to the server spec's and also the bit(32/64) number.

Thanks in advance.
Post #1424331
Posted Tuesday, February 26, 2013 10:51 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, December 15, 2014 3:21 AM
Points: 500, Visits: 282
Hi,
check this specification: http://msdn.microsoft.com/en-us/library/ms143432(v=sql.105).aspx
Databases per instance of SQL Server 2008 R2 - 32,767

Practically this value is limited by the amount of RAM the SQL server machine has, long before it reaches this maximum values.
Post #1424337
Posted Wednesday, February 27, 2013 1:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, November 27, 2014 11:02 PM
Points: 251, Visits: 618
thanks for the link i was searching for the same ..
Post #1424395
Posted Wednesday, February 27, 2013 2:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 6, 2014 11:47 PM
Points: 4, Visits: 7
Thank for the link dude.
Post #1424412
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse