Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is there a limit to the database size or number or users?

April 26, 2017database limit size Users

0

Posted

Is there a limit to the database size or number or users?

1 Answer

0

Posted

SQL Server supports 32,767 databases at a maximum size of 1 terabyte. 2 billion tables per database, 250 columns per table and 32,767 connections per database. For comparison purposes, a Design It! &#174 database managing 1,000 motors, and 6,000 instruments and all the associated cables and connections will require approximately 100MB of disk space.