Per SQL Server Books online, in the section titles maximum capacity specifications, the max possible database size is 1,048,516 TB. As to the practical limits, that I don't know. In February, 2002, Dell discusses testing multi-terrabyte (up to 4 TB) instances
here. (
Downloadable doc file)