Restore and Backup SQL Databases.


Here is how you restore them:
http://www.powerdnn.com/Support/FrequentlyAskedQuestions/Hosting/ConnecttoSQLDatabasewithManagementStudio/tabid/146/Default.aspx

1. In SQL Server 2005 expand "Databases"
2. Right click on your database Tasks>"Restore">"Database..."
3. Make sure the database you want to restore to is shown in the "To database" box
4. Click "From device" and choose the database to restore and hit OK.
5. Check the backup you want to restore.
6. Go to options.
7. Check "Overwrite the existing database"
8. Click OK

Here is how to backup your current database:
http://www.powerdnn.com/Support/FrequentlyAskedQuestions/Hosting/ConnecttoSQLDatabasewithManagementStudio/tabid/146/Default.aspx

1. In SQL Server 2005 expand "Databases"
2. Right click on your database Tasks>"Backup..."
3. Under destination choose a destination, make sure when naming it you name it file.bak
4. Click OK.