SAP@SQL 2008 - capacity

[Former Member]

SAP Business One

SQL 2008

I need best practise suggestion for the my requirement; where 200 distributors are connected to the Principal company. The distributors use SAP business One and Pricipal company use mySAP.

Each Distibutor is an individual entity and will have a individual database; which counts to 200 databases in total.

My questions are,

Can a SQL 2008 handle 200 different databases?

What kind of server setup can handle this bandwidth ?

What is the best way to handle this requirement?

Kindly suggest... thanks

[Former Member]

Can a SQL 2008 handle 200 different databases?

The limitations of SQL Server 2008:

Database size: 524,272 terabytes

Databases per instance of SQL Server: 32,767

Filegroups per database: 32,767

Files per database: 32,767

What kind of server setup can handle this bandwidth ?
What is the best way to handle this requirement? 

You will need a lot of RAM and many many cores... Basically it depends on the data volume that needs to be procecessed and transfered over the network. Any idea how much that will be?

[Former Member]

Can you give a brief explanation on these topics;

Databases per instance of SQL Server (what is an instance?)

Filegroups per database (what is a filegroup?)

Files per database(?)

thanks..

[Former Member]

An instance is basically an installed SQL Server (default instance versus named instance). Every database stores the data in one (primary datafile) or more (secondary) datafiles. These datafiles can be grouped logically to filegroups (similar to the concept of tablespaces). Please check with [Books Online|http://msdn.microsoft.com/en-us/library/ms130214.aspx] to get an overview of the basic SQL Server architecture.