There's no need to worry about CC - there's bags of drive space on the current server and I recently added another 2GB system RAM so it can handle more concurrent processes (more people browsing/posting/etc.).
Whilst the physical size of databases in SQL can be very large, there does come a point where it is no longer practical to run it all from a single server;
when the time comes I'll pop to the shop and get another one and plug it in ...
Cheers,
Shaun