This article may be out of date!
Visit the New Knowledge Center

How to Backup an SQL Database Using Microsoft SQL Server Management Studio Express

Objective:

  • Backup SQL Database to .bak Format
  • Obtain .bak File for Migrating to Clio
  • Backing up SQL

Environment:

Additional Information:

Please note that the success of any data migration depends primarily on the quality of the data set provided to us. Before attempting to migrate your information into Clio, you should ensure that your data is consistently formatted, well organized, sufficiently backed up, and stored securely. If you are not certain, it is recommended that you consult with your Clio representative before proceeding

Procedure:

  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. (This is not available for version 2018/2019)
  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 the 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 it's done.

 

Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality