[Guide] Command Server Database Backup/Restore Procedure

Last Updated: Dec 09, 2017 01:03AM CET

Command Server Database Backup / Restore Procedure:

In anticipation of a catastrophic failure, you should always protect your NovaStor DataCenter command server, as this contains the database required to browse and track your backups.
 
The following steps are critical in creating a backup job to protect your backup server:
 
  1. Create a disk pool for the exclusive purpose of holding only the NovaStor DataCenter database, for ease of recovery. It is recommended to configure a 3-day retention of this database for data integrity.
    NOTE: ONLY use this pool for your NovaStor DataCenter Disaster Recovery Backup job!

    NSDC Recovery
     
  2. Configure some method of replication offsite or in the cloud of this storage pool so you can recover it in case of disaster.
     
  3. Configure the backup job to use the pool that was created exclusively for this purpose with the Fileset containing the “NovaStor” folder in ProgramData and Program Files:
    C:\ProgramData\NovaStor\*
    C:\Program Files\NovaStor\*

     
  4. Create a backup job to capture the NovaStor software installation locations:
    NSDC Recovery

    NSDC Recovery

    NOTE: Make sure to NOT configure Multiplexing and splits on this job, as it makes it almost impossible to restore later.
     
  5. It is recommended that the backup be performed after all other critical data backups and Retention operations have completed:

    NSDC Recovery
 

Restore Procedure:

  1. Retrieve the NSDR pool you have backed up with the software, it will contain some .sv files you will need to perform a direct restore of the data from.
  2. Install the software onto the new machine just as before. No settings or special options needed just a Next, Next, Next, Wait......
  3. Follow the procedure to perform a direct restore of the latest sv file in this pool.
    http://dcsupport.novastor.com/customer/portal/articles/2875406--guide-direct-restore-from-sv-file
  • You can also use the simple_restore.cmd script to do this, simply copy the script into the folder that contains your .sv backup file
 

File copy/overlay (not using DataCenter .sv files)

This is the procedure to manually backup/restore the DataCenter/Network command server before/after a full system reinstall. 
NOTE: This is also the same procedure you would use if you migrate from one machine to another, I.E. Physical machine to Virtual Machine. 

The process to backup and restore to a new install is a very simple process. 

**** Be sure you have the installer for the same version currently installed before starting the backups. ****

**** Installing any upgrade before backup would be a good idea to ensure the versions match. ****


Before doing the migration you will need check where your media pools are storing the backup data. This can be found on the Storage Management tab of the GUI. Each Media Pool will have a path to its storage location. 
  • If these locations are on a NAS device or some other network location, I.E. \\device\storage\Backups, then there is no need to worry, as that path will be the same as it currently is. 
     
  • If you are using a local storage location, i.e. D:\Backups, then you will need to make sure to copy all data in these folders to an external location, or all backup data will be lost.
    • You will also need to be sure to recreate the same local drive partition structure after refresh so the data can be copied back to the same path it is currently configured to look for in the Database (i.e. D:\Backups).
 

Procedure: 

  1. Stop all "NBK DC *" services (You can use the Stop.bat or Stop.ps1 file attached or create your own, see below)
     
  2. Copy the C:\ProgramData\NovaStor\DataCenter folder into a zip file and copy externally.
  3. Copy the C:\Program Files\NovaStor\DataCenter folder into a zip and copy externally.

    **** At this point your database has been copied and is able to be restored to this point in time later. ****
     
  4. Install the software onto the new machine just as before. No settings or special options needed just a Next, Next, Next, Wait......
  5. Once install is complete:  Stop all the services again. (You can use the Stop.ps1 file attached or create your own, see below)
     
  6. Copy the previously backed up folders to their original locations (Program Files and ProgramData) and overlay the current data. If you are concerned, rename the newly created folder and copy the old here.

    **** If needed, copy any moved backup data to their original path (i.e. local storage). Disregard if you store data on a network location. ****
     
  7. Start NBK services and launch the GUI. (You can use the Start.bat or Start.ps1 file attached or create your own, see below)
 

Batch Scripts to stop/start services


Stop.bat is a batch script to stop NBK DC services.
sc stop "nbksrv"
sc stop "DerbyDB"
sc stop "hijacc"
sc stop "hiserv"
sc stop "mpx"
sc stop "OpenEJBServer"
sc stop "rcmd-dispatcher@port:32335"
sc stop "rcmd-executor@port:32334" 
sc stop "DCWebserver"



Start.bat is a batch script to start NBK DC services.

Start.ps1
sc start "nbksrv"
sc start "DerbyDB"
sc start "hijacc"
sc start "hiserv"
sc start "mpx"
sc start "OpenEJBServer"
sc start "rcmd-dispatcher@port:32335"
sc start "rcmd-executor@port:32334" 
sc start "DCWebserver"

 

PowerShell Scripts to stop/start services

Stop.ps1 is a PowerShell script to stop NBK DC services.

Stop.ps1 is a PowerShell script to stop NBK DC services.
"nbksrv", "DerbyDB", "hijacc", "hiserv", "mpx", "OpenEJBServer", "rcmd-dispatcher@port:32335", "rcmd-executor@port:32334", "DCWebserver" | %{ stop-service $_ }


Start.ps1 is a PowerShell script to start NBK DC services.

Start.ps1
"nbksrv", "DerbyDB", "hijacc", "hiserv", "mpx", "OpenEJBServer", "rcmd-dispatcher@port:32335", "rcmd-executor@port:32334", "DCWebserver" | %{ start-service $_ }
 

Tips & Tricks from us to you

  • Try utilizing a Task Scheduler entry to run a RoboCopy script to create a spare copy of the C:\ProgramData\NovaStor & C:\Program Files\NovaStor folders and zip them with the current date (if you wish)
    • You can then have a Cloud sync program target these copies to have it offsite in case of failure (i.e. Google Drive, Dropbox, OneDrive, Amazon Drive, etc.)
http://assets3.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete