SQL server 2005

  • hello friends.. i am new to the work .. and there is adoubt in the database size.. the client is a small retail company.. and there wil be 20 employees(USERS) working and daily transactions would be 30 invoices to be entered daily.. now we have six field and the problem is with the database size.. there are 130 to 150 tables.... could any one please help me in suggesting the size of the database... 4gb is the limit clinet has ordered... please give ur ideas of how the database size to be thought and about the back up of the data ... do we have tp take individual databases for each field (6FIELDS).... or produce one central database (of what size if so ) for all the fieldss..

    wil be waiting eagerly for the answer .. thanks in advace frens ..

  • You may want to rephrase your question.

    Are you asking what you should set the autogrowth to be? or Are you asking how big your database is going to be with 150 tables with 6 fields in each table?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply