0. Create a database instance first:
1. create the required table
2. Create a primary key and an external key
3. Set Constraints
------------------ Back up the database ----------------------------------
1. Create a backup device first
Console-> Management-> Backup-> right-click Create Backup Device
Displayed after creation, for example:
2. Create a backup database.
Select the database to be backed up and choose tools> backup database, as shown in:
Click Add to display the select backup target dialog box, as shown in:
Click OK, as shown in the following figure:
Click to display the successful backup dialog box:
-------------------------- Restore database -------------------------------
1. Delete the original database first
2. Create a database
3. Restore the database
Additional: Backup and Restore link for SQL Server 2008: http://wenku.baidu.com/view/525da580e53a580216fcfe47.html