The process of determining how much space your database requires is fairly straightforward.
The amount of space is equal to the sum of the following:
* Space required for data
* Space required for indexes
* Space required for temporary data
* Space required for the transaction log
Source:
Microsoft SQL Server 2000 Administrator's Companion eBook