Cinegy File Service can monitor any number of SQL Servers and databases. You can install it on an SQL Server machine, or on a separate server (for example, you can use the server where all the gateways are running). It also tracks files moved by an HSM System for later retrieval.



Connecting to File Service

Because Cinegy File Service can monitor different SQL Servers, the setting is stored locally in the registry and not in the database. Therefore, for every machine on which you run Cinegy Enterprise Manager, you have to connect to the service manually once.

  1. If the service is run on the same machine, press the "Local computer" button.

    31_DBM_CFS_main_local PC
  2. Otherwise, browse for the machine with the service. Press the "Connect to a remote" button. The following dialog box appears:

  3. Select the machine from the list and press the "Select" button.

  4. If the connection is successful, "Status" will be "Running" in green. 31_DBM_CFS_main

You have to connect to the service every time you invoke the dialog.

Setting the Refresh Interval

Enter the refresh time in milliseconds into the "Refresh timeout" field.

The value depends on the size of your disks. Do not set the value smaller than 10000 milliseconds (10 sec), as this will create unnecessary overhead.

Log Errors

Logs contain events logged by applications or programs. For example, a program records a file error in the application log and administrators can decide what the problems is.

"Log errors" will count the errors regarding the Cinegy File Service.

Log Info

If Microsoft Event Viewer received the event type "Information" regarding Cinegy File Service, it will show how many events are available.

See more details about filtered events in the Events paragraph.

Disable a File Recall

If you are using the archive storage system and would like to be able to retrieve files moved by archive system, the "Disable a file recall" option has to be set to "0".

The "Disable a file recall" option should be set to "1" to disable the archive storage system support via Cinegy File Service.

Full File Read During Recall

By default, Cinegy File Service reads only the file header to force the 3rd party digital archive systems restoring a file from the archive. Some tape- or non-tape based archive libraries support the partial file restoring based on byte offset to accelerate the media files management. In such case, the subsequent operations with media file can cause recurring data restoring from tape resulting in delays and freezes. To prevent a similar situation from occurring, the archive storage system should be configured to fully restore a file on any read attempt. Alternatively, Cinegy File Service should be configured to read the entire file.

To enable full file restore functionality, set the "Full file read during recall" option to "1" and you will retrieve the entire media file for reading.

Low Free Space Limit

Enter the "Low free space limit" value to indicate when to switch the locations to non-active to avoid disk fragmentation.

"20%" is the default and recommended value for free space limit. When this limit is exceeded, the location will be deactivated. After the cleanup, the share will automatically be enabled.

Disable Shared Storage Status Changing

The "Disable shared storage status changing" option should be set to "0" to enable the above mentioned automatic deactivation of a certain location via the Cinegy File Service. The "Disable shared storage status changing" option should be set to "1" to disable the automatic free space control.

Adding a New Database for Watching

To add a new database, do the following:

  1. Press the "Browse" button next to the "SQL Server name" field to select a server. 31_DBM_CFS_add_database

  2. Select the database name in the drop-down list next to the "Add" button. 31_DBM_CFS_add_database1

  3. Press the "Add" button.

  4. Press the "Save" button: 31_DBM_CFS_main

  5. "Stop" and "Start" the service to refresh its settings.

Deleting a Database from the Watch List

To remove a database from the list of monitored databases, do the following:

  1. Select a database in the "Databases" list box.

  2. Press the "Delete" button.

Offline Files

The "Offline files" button shows the list of files moved to an HSM System.


Go to the "Events" tab to view all the system or application events related to the service. This is for your convenience because the events are usually shown only in Windows Event Viewer.


Here filter the event types to be displayed choosing the desired option from the corresponding drop-down list:

32_DBM_CFS_Events_types filter