Database Setup

Database Setup

Setup

Please make sure that Fulltext Services are installed (see System Requirements)!
The following steps need to be performed to setup the eRecruiter database.
  1. Database
    1. Database should be named eRecruiter
    2. Data file should have an initial size of 500 MB, auto-grow by 100 MB without limit.
    3. Transaction log should have an initial size of 100 MB, auto-grow by 10% with 10 GB limit.
  2. Database User
    1. When using Windows authentication (connection through integrated security) the user should be selected from the operating system.
    2. When using SQL Server authentication the user should be named erecruiter with a strong password that does not expire.
    3. The default language should be set to German.
    4. The default database should be set to the database created in step 1.
  3. User Mapping
    1. Grant access to the database from step 1 with db_owner permissions.

Schema

After the database has been created and the user has been setup, execute the schema creation script provided in the installation support package.

Seed

After the database schema has been created, execute the database seed script provided in the installation support package.

    • Related Articles

    • Maintenance / Monitoring

      After the successful installation the following topic should be considered in order to setup a monitored and maintained system: Backup / Restore Directory Structure DNS Double-Opt-In Google Tag Manager Monitoring Security Recommendations SMTP ...

    • Application Installation

      This section will explain how to acquire the installation package and copy the application into the proper directories. The link for installation package download will be provided by the eRecruiter consultant or support upon request as it will ensure ...

    • System Requirements

      SaaS Client-Software Due to the fact that eRecruiter is a web-based recruiting tool, the only requirement for clients/users is a modern web browser. Please note, that we can only support webbrowsers that are also supported by the distributor due to ...

    • Preparation

      In the step the server will be prepared for the installation. In order to start with this step the eRecruiter setup package and eRecruiter setup support package are required. These packages will be submitted by the eRecruiter operations team along ...

    • Backup / Restore

      The eRecruiter requires a backup and restore concept to avoid data loss in case of a critical system failure. The following documentation can be used as a draft to create a company-specific concept. Database The backup of the database can be ...