By default, all Celiveo 8 databases are hosted on one server. If this server fails, or is unable to connect to the network, these databases must be restored to a different server.
The host name of the replacement server should be the same as that of the server that crashed. If the host name is different, all Celiveo Virtual Printer clients must be reconfigured to work with the new database server.
The procedures outlined below uses SQL Server Management Studio as the database management tool, and assumes that the databases have been backed up to *.bak files. SQL Server Management Studio is a free tool, which you can download from https://www.microsoft.com/en-sg/download/details.aspx?id=29062. If you do not use SQL Server Management Studio, use these instructions only as a guideline to update your disaster recovery documentation.
Database Restore Procedure
From the Start Menu, run SQL Server Management Studio.
Connect to the Database Server hosting the database.
In the Tree View, right-click the Databases node and click Restore Database.
In the Source section, select the Device option.
Click the Ellipsis button (... ) next to Device. The Specify backup devices dialog displays.
From the Backup media type list, pick File.
Click Add.
Navigate to the backup file for the CeliveoDB database (CeliveoDB.bak) and select it.
Click OK until you return to the Restore Database dialog.
In the Select a Page section, click Options.
Select the following check boxes:
Overwrite the existing database (WITH REPLACE).
Close existing connections to destination database.
Click OK.
Repeat steps 3 through 10 and restore the SJPS database (SJPS.bak), and if Track-GreenSaver is installed, the PrintManager90 database (PrintManager90.bak).
Celiveo EMEA Support
By default, all Celiveo 8 databases are hosted on one server. If this server fails, or is unable to connect to the network, these databases must be restored to a different server.
The procedures outlined below uses SQL Server Management Studio as the database management tool, and assumes that the databases have been backed up to *.bak files. SQL Server Management Studio is a free tool, which you can download from https://www.microsoft.com/en-sg/download/details.aspx?id=29062. If you do not use SQL Server Management Studio, use these instructions only as a guideline to update your disaster recovery documentation.
Database Restore Procedure