How much space does my DB use?
These two commands give you some nice summary info about your database:
sp_helpdb MY_DATABASE_NAME go sp_spaceused
(...including the names of the .mdf and .ldf files which you'll use for the Backup restore script)
To see available space use: