How do I Backup and Restore my SQL Database?

How do I Backup and Restore my SQL Database?

It is important to back up your CurrentWare 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.

Database Backup Scheduler

On the CurrentWare console, you can configure CurrentWare to back up the SQL database periodically.

  1. Tools > Database Backup Scheduler > Enable database backup scheduler
  2. Select a path to store the database backup
  3. Set the frequency and time of the backup

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

  1. Launch the CurrentWare Server Manager
  2. Type CWSM.exe on the start menu > Launch CWSM.exe
  3. On the CurrentWare Server Manager Database > 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

Restoring the CurrentWare 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.

  1. Launch the CurrentWare Server Manager
  2. Type CWSM.exe on the start menu > Launch CWSM.exe
  3. On the CurrentWare Server ManagerDatabase > Archive and Restore
  4. 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

  1. Turn off CurrentWare Server Services
  2. Run Microsoft SQL Server Management Studio
  3. Right-click on your CurrentWare SQL database
  4. Select Tasks then Restore
  5. Select the backup set you want to restore then select OK
  6. Start the CurrentWare Console or CurrentWare Server Services again.

Don't have CurentWare Installed? Download & Get started with a free trial!