How many Database can be created in a MSSQL 2008

• vijay 18165

  Grasshopper

  Points: 20

  More actions

  February 26, 2013 at 10:39 pm

  #290034

  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.

• zzalina0

  SSCommitted

  Points: 1524

  More actions

  February 26, 2013 at 10:51 pm

  #1591387

  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.

• jeetsingh.cs

  SSCommitted

  Points: 1761

  More actions

  February 27, 2013 at 1:49 am

  #1591440

  thanks for the link i was searching for the same ..

• vijay 18165

  Grasshopper

  Points: 20

  More actions

  February 27, 2013 at 2:41 am

  #1591456

  Thank for the link dude.