Database size allocation - where other than tables, logs, etc ?

I have a Db that is 1.7 gigs. The table data takes approximately 200megs. The transaction logs were truncated. Where else can this large size be coming from and how can I confirm?

DB is generally small. ~25 tables, 100 SPs, 10 views, etc.

Note:

I have 4 queues using SQL Notifications, but when selecting from them results in no data.

Thanks

Scott

sp_spaceused can give you some details about data space. sp_helpfile will show data and log file sizes.

You may just need to shrink your database to get the file sizes down using DBCC SHRINKDATABASE or SHRINKFILE.