Change the CurrentWare Database Backup Location

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 a different location for your backup you will need to download and install SQL Server Management Studio (SSMS).
Find the download for SQL Server Management Studio here: Microsoft SQL Server Management Studio (SSMS)

Once you have Sql Server Management Studio (SSMS) installed, follow the steps to guide you through changing the location.

  1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, expand the server tree.
  1. Expand the Databases, right-click CWNPSQL, select Tasks, and then select Back Up.

  1. On the General page in the Destination section select Disk from the “Back up to:” drop-down list.
  1. Select Add and the Select Backup Destination dialog box will open.

  1. Enter the path and file name in the File name text box and use .bak as the extension.
  1. Select OK and then OK again to start the backup.
  1. When the backup completes successfully, select OK to close the SQL Server Management Studio dialog box.

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

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

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

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

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