Sally,

You define the initial size of a SQL Server database when you create it. For example, you can decide to start with 20MB (if that makes sense for you app). You can also tell SQL Server to automatically increase the size of the database when it fills the space that you allocated for it. You can tell it to increase the size by other X amount of MB or by a % of the current size.

I guess you'll need to create a pilot database on your local system and fill it with some data to give you an idea of how big should you start with.


>Hi Cathi,
>
>Nice job with Kevin on the book! That's the text I'm using to move from VFP to ASP.NET.
>
>The web hosting site already has loaded the framework, etc. They charge for using ASP.NET and SQL Server. So I guess my question is how much space will my site take up now that it is ASP and SQL Server. This is a crazy question since how are you supposed to know <g> but I thought maybe there were some general guidelines like "my SQL Database has 20 tables with approx 1,000 records in each and the site has maintenance screens for 10 of the tables and another 10 screens for order entry, shipping, etc. and it takes up xxxMB for data and xxMB for ASP code". Possible to give me an example knowing that mine will be different?
>
>Thanks!
>
>
>>Hi Sally,
>>
>>This depends if you are installing just the redistributable version of the .NET Framework (70 MB), the SDK version of the .NET Framework (370 MB), or Visual Studio .NET (2.5 GB - 3.5 GB, depending on the version).
>>
>>>I'm just diving into ASP.Net for the first time. I am converting a VFP app to run on a website with ASP.Net (VB.Net behind). I know the disk space required of the app in VFP and I know you can't tell me how much it will require under .NET but how much space do the "basics" take up? We will be running on a shared server so I am trying to get a ballpark hosting cost.
>>>
>>>Thanks for helping!
>>>
>>>Sally