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 Once
On the CurrentWare console, you can backup your CurrentWare database once manually.
From the CurrentWare Web Console go to Tools > Database Backup Scheduler
Click on “Run Backup Now”
The backup database is stored under C:\Program Files\Microsoft SQL Server\MSSQL14.MYPROD\MSSQL\Backup\
2. Database Backup Scheduler
On the CurrentWare console, you can configure CurrentWare to back up the SQL database periodically.
From the CurrentWare Web Console go to Tools > Database Backup Scheduler
Check the option “Enable Scheduler”
The backup path is set to the default SQL backup directory
Set the frequency – daily, weekly or monthly
Set the time, day or month
Set the start time of the backup job
3. Restoring a SQL database using SSMS
Turn off CurrentWare Server Services
Run Microsoft SQL Server Management Studio
Right-click on your CurrentWare SQL database
Select Tasks then Restore
Select the backup set you want to restore then select OK
Start the CurrentWare Console or CurrentWare Server Services again.
4. Archive & Restore Database
Archiving the CurrentWare SQL database will back up the live database and replace the live database with a new one. This optimizes the performance of CurrentWare by reading and writing on a fresh database.
Launch the CurrentWare Server Manager
Type CWSM.exe on the start menu > Launch CWSM.exe
On the CurrentWare Server ManagerDatabase > Archive and Restore > Select Archive
The
archived SQL Database will be saved and located in C:\Program
Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Backup\Archive
5. Restoring an Archived Database
The procedure to restore the CurrentWare database depends on your back up method. If
you used the CurrentWare Server Manager to archive your database, you
can restore the archived database from the CurrentWare Server Manager as
well.
Launch the CurrentWare Server Manager
Type CWSM.exe on the start menu > Launch CWSM.exe
On the CurrentWare Server ManagerDatabase > Archive and Restore
Select an archived database from the drop-down menu > Select Restore
If you used a backup scheduler, you can use Microsoft SQL Server Management Studio to restore the database
I want to change the backup location
Please see this article to see the steps on changing where your CurrentWare database backup will go.
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 ...
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 ...
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 ...
By default, the CurrentWare install of SQL Express has a 10GB size limit. This means you can store up to 10GB of data on-prem without any changes on your end. CurrentWare will not automatically remove your data. You must manually set up the ...
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 ...