Do the following tasks to take a backup of a database:

Steps :

1.    Go to Start>>Programs >>Microsoft Server 2005>>SQL Server Management Studio, Click SQL Server Management Studio. Microsoft Server Management Studio window with Connect to Server dialog box appears (see Figure 1).

2.    Enter a password of the server in Password field.

3.    Click Connect. It connects to the database server and Microsoft Server Management Studio window refreshes (see Figure 2).

4.    Expand Databases subfolder under Test_Server\SQLExpress folder (see Figure 3).

5.    Right-click a database that you want to take a backup. A shortcut menu appears (see Figure 4).

6.    Click Tasks>>Back Up.. Back Up Database dialog box appears (see Figure 5) displaying the selected database in Database list.

7.    Click Add in Destination section. Select Backup Destination dialog box appears (see Figure 6).

8.    Click … button beside File name field. Locate Database Files dialog box appears (see Figure 7).

9.    Browse to select a path.

10.    Enter file name in File name field.

11.      Click OK. Select Backup Destination dialog box refreshes (see Figure 8) displaying the selected path in File name field.

12.    Click OK. Back Up Database dialog box refreshes (see Figure 9) displaying the selected backup path in Destination list.

13.    Click OK. A message appears (see Figure 10) to a user for confirmation after completing the backup of database successfully.

Source: Microsoft