h1

Backing up an SQL Express database to a file

February 22, 2008

Backing up an SQL Express database to a file is a simple process… once you know what to do.

  1. Open SQL Server Management Studio Express and connect to the SQL server.
  2. Expand Databases.
  3. Right-click on the database you want to back up, then select Tasks > Back up.
  4. On the Back Up Database window, make sure the Database field contains the name of the database you want to back up.
  5. Select the Backup Type. By default, it is Full – leave it set to that.
  6. Click Remove to remove the default/last backup file name.
  7. Click Add to open the Select Backup Destination window.
  8. Click […] next to the File Name field.
  9. On the Locate Database Files window, select the folder where you want to backup file to go. By default, it is ..\Microsoft SQL Server\MSSQL.1\MSSQL\Backup.
  10. In the File Name field, type the name for this backup, with a .bak extension. For example, xyz_20080221.bak for a backup of the XYZ database created on 21 February 2008.
  11. Click OK to close the Locate Database Files window.
  12. Click OK to close the Select Backup Destination window.
  13. Click OK to start the backup. The progress icon displays in the lower left corner, and a ‘completed successfully’ message displays when its done.

See also:

4 comments

  1. I found your site on google blog search and read a few of your other posts. Keep up the good work. Just added your RSS feed to my feed reader. Look forward to reading more from you.

    – Sue.


  2. […] Backup the database on computer A to a file. […]


  3. […] Backup the database on computer A to a file. […]


  4. please tell me the code for backup in c#.net from sql Express



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

%d bloggers like this: