Page Comparison

...

• SQL 2008

• SQL 2012

• SQL 2014

• SQL 2017

• SQL 2019

Backing Up Using SQL

...

If you are backing up the Velocity database using SQL 2008, use this procedure:

1. Right-click on the Velocity Service Control Manager (SCM) icon on the source computer, stop all Velocity services, then select the Exit option to exit SCM.

2. Open Microsoft SQL Server Management Studio; from the Windows desktop, select Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio.
   The Connect to Server dialog appears:

   Image Removed

3. Click Connect.

   The Microsoft SQL Server Management Studio screen appears:

4. In the left tree pane, expand the Databases folder to reveal the Velocity database.

5. Right-click on the Velocity database. A pop-up menu appears.

   Image Removed

6. Select Tasks > Back Up...
   The Back-Up Database –> Velocity dialog appears:

   Image Removed

   If one or more backups are already displayed in the Destination pane, remove them by highlighting the device and clicking the Remove button.

7. Click the Add... button to the right of the Destination pane.
   The Select Backup Destination dialog appears:

   Image Removed

8. Click to select the File name radio button.

9. In the ‘Filename’ field, place your cursor at the end of the path and type a name for the database file you are about to create. For example, Velocity_backup.bak.
   Make note of the path where this backup file is created, because you will need to access the file during a later step.

10. Click OK to close this dialog and return to the Back Up Database –   Velocity dialog.

    The new file name now appears in the Destination pane.

11. Click OK again.

    The current Velocity database is backed up to the selected destination. A message appears indicating that the database was backed up successfully.

12. Click OK.

13. Exit the SQL Server Management Studio.

Backing Up Using SQL 2012

If you are backing up the Velocity database using SQL 2012, use this procedure:

...