SQL Server 2000 TABLE creation, data backup and Restoration

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