How To Backup Your SQL Database For Support

How To Backup Your SQL Database For Support

Getting Your SQL Database Backup

Sometimes the CurrentWare support team may request a copy of your database via a backup. This is usually rare and when handling your database the team follows a strict security protocol to ensure all data is secure.
The best way to get a backup would be to use SQL Server Management Studio.

You will need to take a backup with SQL Management Studio.  SSMS can be downloaded Here.
Once installed use the following steps to take a backup of the SQL database.
  1. Launch SSMS (SQL Server Management Studio)
  2. Connect to your SQL Database Engine.  If using the default SQL Express you should see a prompt similar to the below image and can click the Connect button.
  3. In the Object Explorer pane expand the Databases folder by clicking on the plus to the left of the folder.
  4. Right-click on the SQL database for Currentware, (The default database name is CWNPSQL) select the Tasks menu item, and then select Back Up... from the sub-menu.
  5. The Back Up Database window should look like the below screenshot.  Take note of the path in the Destination section as this will be the path and filename for your backup. 
  6. Click on OK to begin the backup.
  7. When the backup completes successfully you will get the following message and your backup file will be in the path noted previously.  
  8. Navigate to the destination path from the backup and right-click > send to > compressed (zipped) folder for the latest .bak file for your database.
  9. Upload the zipped folder to the logs location as requested by support

    • Related Articles

    • Backup and Restore the SQL Database

      It is important to back up your CurrentWare SQL database to ensure that you retain your historical information from CurrentWare’s solutions such as BrowseReporter and AccessPatrol. There are a few ways to back up the CurrentWare database. 1. Backup ...

    • How do I enable automatic database backup?

      On the CurrentWare console, you can configure CurrentWare to backup the database periodically. Go to Tools > Database Backup Scheduler To turn it on hit the checkmark beside Enable Scheduler. Select a path to store the database backup. Set the ...

    • Change the CurrentWare Database Backup Location

      Using the CurrentWare application to backup only gives you the option to use the default SQL folder backup location. The backup must be in the default folder for SQL to recognize it. This page will help you change the location for the backups. To use ...

    • Move the CurrentWare server to another computer with network SQL database

      When moving your CurrentWare software to a new server/PC you need to make sure you do not have both consoles connecting to the same networked database. Here are the steps to take. #1 Back up your existing cwServer Database Before you migrate your ...

    • Security & SQL Database Best Practices

      Security and Workflows Connection to the Web Console Starting with v8.0.1, the CurrentWare web console will have a preconfigured self-signed SSL certificate that is enabled by default. This will ensure that network communication to and from the ...