SQL2005 Database Backup Procedure

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).

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).

Figure 2

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

Figure 3

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

Figure 4

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

Figure 5

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

Figure 6

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

Figure7

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.

Figure 8

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

Figure9

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

Figure 10

Source: Microsoft

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s