Windella Computer Knowhow

Topics

Elevate Database

Installing Elevate Database Server

Starting Elevate Database Server as an Application

Starting Elevate Database Server as Service

Where are my backup files?

Backup your backups

What is a Store?

Restoring a database

Configuration files

Database Configuration file

Changing the Database Location

Elevate Database

Elevate Database is a robust SQL database that is highly compliant to SQL 2003 standards.

It can operate as a Client-Server database or as a file-sharing database (like Microsoft Access).

Installing Elevate Database Server

The Elevate Database Server is named EDBSrvr.exe

If you wish to run the ElevateDB Server as a Windows service you must install it as a service by running the ElevateDB Server with the /install command-line switch set.

For example, to install the ElevateDB Server as a service using the Run command window under Windows you would specify the following command.

edbsrvr.exe /install

To uninstall the ElevateDB Server as a Windows service you must run the ElevateDB Server with the /uninstall command-line switch set. For example, to uninstall the ElevateDB Server as a service using the Run command window under Windows you would specify the following command.

edbsrvr.exe /uninstall

If you wish to install the ElevateDB Server so that it does not interact with the desktop at all, which is required in instances where the current user will be logged out of the system, then you should use the /nointeract flag along with the /install command-line switch. This will install the service as a non-interactive service and the ElevateDB Server will not display a user interface when it is started.

edbsrvr.exe /install /nointeract

By default the service will display a "Service installed" dialog box when the service is installed successfully. This is sometimes not desired during installations, and in these cases you can use the /silent command-line switch to suppress the dialog box.

edbsrvr.exe /install /silent

Starting Elevate Database Server as an Application

In Windows Vista and Windows 7, the following steps may need to be performed to avoid problems with user access permissions.

  1. Set the edbsrvr.exe to WinXP compatibility mode (right click and look for compatibility tab).
  2. Ensure Read/Write/Full control permissions are set for the edbsrvr.exe folder and EDBSrvr.ini folder - (%AllUsersProfile%\Application Data\Elevate Software\ElevateDB Server
  3. Ensure User Access Control is set to Off

You can start and configure the ElevateDB Server as a normal application by completing the following steps.

  1. Find the folder location of the ElevateDB Server (edbsrvr.exe)
  2. Run this application.
  3. Make sure that the configuration file folder is set to the desired folder:
    • In the system tray, right-click on the ElevateDB Server icon to bring up the server menu and click on the Restore option on the server menu.
    • In the Tasks pane, click on the Stop Server link.
    • In the Tasks pane, click on the Edit Server Options link.
    • Under the Configuration tab, make sure that the Configuration File - File Folder is set to the desired folder. This is normally the Databases folder.
    • Click the OK button
  4. In the Tasks pane, click on the Start Server link.
  5. Click on the Close button in the upper-right-hand corner of the ElevateDB Server window to close the server window.

Starting Elevate Database Server as a Service

The main difference between starting the ElevateDB Server as a normal application and starting the ElevateDB Server as a Windows service is that the normal application can be started just like any other application via Run dialog, command-line, or via a Start Menu program link or desktop link, while the service must be either started via the Services dialog or by using the NET START command-line command.

In Windows Vista and Windows 7, the following steps may need to be performed to avoid problems with user access permissions.

  1. Set the edbsrvr.exe to WinXP compatibility mode (right click and look for compatibility tab).
  2. Ensure Read/Write/Full control permissions are set for the edbsrvr.exe folder and EDBSrvr.ini folder - (%AllUsersProfile%\Application Data\Elevate Software\ElevateDB Server
  3. Ensure User Access Control is set to Off

To start the ElevateDB Server as a service using the Run command window under Windows you would specify the following command.

net start edbsrvr

Alternatively, the Elevate DB Server can be started from the Services dialog. Use Adiminstrative Tools, Services in the Control Panel to start the service.

You can configure the ElevateDB Server as a service by completing the following steps.

  1. Make sure that the configuration file folder is set to the desired folder.
    • In the system tray, right-click on the ElevateDB Server icon to bring up the server menu and click on the Restore option on the server menu.
    • In the Tasks pane, click on the Stop Server link.
    • In the Tasks pane, click on the Edit Server Options link.
    • Under the Configuration tab, make sure that the Configuration File - File Folder is set to the desired folder. This is normally the Databases folder.
    • Click the OK button
  2. In the Tasks pane, click on the Start Server link.
  3. Click on the Close button in the upper-right-hand corner of the ElevateDB Server window to close the server window.

Where are my backup files?

After starting your database application, perform the following steps to access your backup files.

  • Click Utilities, Backup
  • Click the Open Folder button

The backup folder is opened, allowing you to copy or email your backup files.

Backup file have an extension (the characters following the last dot in the filename) of EDBBkp. Ensure that the date and time of the backup file is correct.

Backup your backups

A backup of your database is created the first time the system is started each day.

It is important to copy these backup files to a safe place in the event of your computer disk being destroyed.

To determine the location of your backup files:

  • Click Setup, Configuration
  • Click the Folders tab
  • Tab to (or click in) the Backup folder edit box
  • Click the Open Folder icon (last icon of the first row)

This backup folder must be included in your daily backup job to ensure that your data is secure.

What is a Store?

A STORE is a folder (or directory) location that has been given a name. This means you can refer to a folder by simple name rather than typing a long folder path.

Backups are saved to a STORE rather than a folder location.

Using EDB Backup Manager, you can create and view stores.

Restoring a database

In the event of unrecoverable database errors, the Database needs to be restored from the backup files.

  • Download and install the EDB Backup Manager.
  • Before the database is restored, backup the existing database.
  • Click the Configuration File button and ensure that the location of the Configuration File is correct. The configuration file is usually named Config.EDBCfg and is located in the folder \databases on either the C:\ drive or a network drive.
  • Click the Stores button and the Open store button. Ensure that the required backup file is in the Store folder.
  • Click the Databases button and select the required database.
  • Click the Alter database location button and change the location of the database. This ensures that the original database is not overwritten when it is restored.
  • Click the Restore button
  • Ensure that the correct database backup file is selected before the database is restored.

Location of Configuration files

Configuration information is stored in the Windella Computer Knowhow folder in the Application Data (Windows XP) or ProgramData folder (Windows Vista/7).

This location can be accessed by entering %allusersprofile%\Application Data\Windella Comnputer Knowhow (Windows XP) or %allusersprofile%\Windella Comnputer Knowhow (windows Vista/7) in Windows Explorer or My Computer.

These configuration files store database information and saves the position and size of the windows.

Database Configuration file

Below is an example Database Configuration file. This file is stored in the Application Data or ProgramData folders.

The SessionType can be either stRemote or stLocal.

If it is a remote session, then the ElevateDB Server must be running as a service on the machine with the RemoteAddress.

If it is a local session, then ElevateDB Sever is not required. The database operations are performed on the client machine and not on the server.

          [DB]
          ConfigLocation=\\wck\Databases
          Database=ExampleDatabase
          
          [dmData]
          SessionType=stRemote
          RemoteHost=
          RemoteAddress=192.168.0.3
          RemotePort=12010
          RemoteService=

Changing the Database Location

The EDB Backup Manager program can be used to change the location of the database.