I managed to put together into a Microsoft Excel spreadsheet the formulas to calculate how to estimate the size of a database. The formulas are based on information found in the SQL Server Books Online at Estimating the Size of a Database. The formulas might differ in other editions.

The files listed below should allow you to get a pretty close idea of the disk space required for tables, clustered indexes and nonclustered indexes. I did not include space required for storage of Large Object (LOB) data types. Quoting from the SQL Server Books Online: “the algorithm to determine exactly how much space will be used to store the LOB data types varchar(max), varbinary(max), nvarchar(max), text, ntext, xml, and image values is complex. It is sufficient to just add the average size of the LOB values that are expected and add that to the total heap size”. This also applies for LOB data type columns being used in clustered and nonclustered indexes.

All you have to do is fill in the values in the separate worksheets where the cells are NOT shaded. If the SQL Server database you are planning requires more than fifty objects per worksheet just copy the last row, making sure to include the formulas, formats, etc.