Show TOC

Procedure documentationBacking Up a Database

Procedure

Backing up a database doesn’t really fall into the category of utilities for troubleshooting but it is a highly recommended task to perform regularly. Existence of a backup makes solving problems much simpler.

To backup a database:

  1. In SQL Central, click the Utilities folder in the left pane to display a list of SQL utilities in the right pane.

  2. Double-click Backup Database.

  3. In the next dialog box, click the top radio button and type the path to the database you want to back up.

  4. Click Next.

  5. In the User Id field type DBA, and in the Password field type SQL. Click Next.

  6. Specify the path where the backup will be saved.

  7. At the bottom of the dialog box you must check the button corresponding to the option(s) you wish to save. You can save one or both of the Main Database File and the Transaction Log File.

  8. In the next dialog box, you must specify what is to be done with the selected database’s logs.

    • Rename or Erase the old one and start a new log with another name.

    • Continue using the original log.

  9. The last dialog box verifies which database is being backed up and where the backup will be placed.

  10. Click Finish to complete the backup.