backup and restore a MSSQL database

Per this:

1. Back-up a database in MSSQL:

   Right-click on a database in MSSQL Management Studio Express 2008 and pick "Back Up..." under "Tasks." You will need to specify something like this...

   C:\Program Files\Microsoft SQL Server\WHATEVER\MSSQL\Backup\

   ...for the where-to-back-up-to setting.
    

2. Tasks > Restore > Database... is where one should restore from