Page Comparison

...

• SQL 7 or MSDE

• SQL 2000

• SQL 2005 or SQL 2005 Express

• SQL 2008

• SQL 2012

• SQL 2014

• SQL 2017

• SQL 2019

Backing Up Using SQL

...

 If you are backing up the Velocity database using either SQL 7 or MSDE, use this procedure:

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

2. To open SQL Manager, from the Windows desktop, select Start > Programs > Hirsch Electronics Velocity > SQL Database Manager.
   If you are using a full version of SQL Server, such as SQL Server 7, we recommend that you use the SQL Database Manager rather than the Database Manager module in Velocity.

   The SQL Server Manager screen appears like this example:

   Image Removed

3. From the left tree pane, expand the Databases folder to reveal the Velocity database.

4. Right-click on the Velocity database.

   A pop-up option list appears.

5. Select All Tasks > Backup Database

   The SQL Server Backup – Velocity dialog box appears like this example:

   Image Removed

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

6. Click the Add... button to the right of the Destination window. The Choose Backup Destination dialog box appears like this example:

   Image Removed

7. From the drop-down list, click the down arrow, and select the <NewBackupDevice>option.

   The Backup Device Properties → New Device dialog box appears like this example:

   Image Removed

8. Type the name for your new backup device and click OK.
   Make note of the path where this backup is being created. You will need to access the file in a later step.
   The Choose Backup Destination dialog box reappears like this example:

   Image Removed

9. Click OK.

10. The SQL Server Backup – Velocity dialog box reappears with the selected backup device displayed like this example:

    Image Removed

    Make sure that only one backup device appears in the window.

11. Click OK.

    The current Velocity database is backed up to the selected destination. When complete, a message appears indicating that the database was backed up successfully.

12. Click OK.

13. Exit the SQL Database Manager.

Backing Up Using SQL 2000

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

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

2. To open SQL Enterprise Manager, from the Windows desktop, select Start > Programs > Microsoft SQL Server > Enterprise Manager.
   The SQL Server Enterprise Manager dialog box appears.

3. From the left tree pane, expand the Databases folder to reveal the Velocity database.

4. Right-click on the Velocity database.
   A pop-up option list appears.

5. Select All Tasks > Backup Database.
   The SQL Server Backup ->Velocity dialog box appears like this example:

   Image Removed

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

6. Click the Add... button to the right of the Destination window.
   The Select Backup Destination dialog box appears like this example:

   Image Removed

7. Click to select the File Name radio button.

8. Place your cursor at the end of the path under the file name option 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 is being created. You will need to access the file in a later step.

9. Click OK to return to the SQL Server Backup – Velocity dialog box.

   The new file name now appears in the Destination window.

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

11. Click OK.

12. Exit the SQL Enterprise Manager.

Backing Up Using SQL 2005 or SQL 2005 Express

If you are backing up the Velocity database using SQL 2005 or SQL 2005 Express, use this procedure:

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

2. To open SQL Server Management Studio, from the Windows desktop, do one of these:

   • If this is SQL Server 2005, select Start -> Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio.

   • If this is SQL Server 2005 Express, select Start -> Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio Express.
     The Connect to Server dialog box appears like this example:

     Image Removed

3. Click Connect.
   The Microsoft SQL Server Management Studio or Microsoft SQL Server Management Studio Express screen appears like this example:

   Image Removed

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

5. Right-click on the Velocity database.

   A pop-up option list appears.

6. Select Tasks > Back Up...

   The Back-Up Database– Velocity dialog box appears like in this example:

   Image Removed

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

7. Click the Add... button to the right of the Destination window.

   The Select Backup Destination dialog box appears like in this example:

   Image Removed

8. Click to select the ‘File Name’ radio button.

9. At the ‘File Name’ 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 is created since you will need to access the file in a later step.

10. Click OK to return to the Back-Up Database – Velocity dialog box.

    The new file name now appears in the Destination window. Make sure that only one backup file appears in the window.

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 2008

...