Info about Maximum specifications for SQL Server 2008/2005

A quick info where you can find the Maximum specification for SQL Server 2008/2005 (32 bit & 64 bit).

SQL Server 2008 – Max Specification

SQL Server 2005Max Specification

There it is some big max possibility in SQL Server:

Database size – 524,272 TB
Databases per instance of SQL Server – 32,767
Filegroups per database – 32,767
Files per database – 32,767
File size (data) – 16 TB
File size (log) – 2 TB
User connections – 32,767

etc etc

Stay Tuned!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s