Database Backup Guide

Database Backup Guide

Step 1 - Executing Database Backup script

1. Download the SQL file provided under attachment(s).

2. Open Microsoft SQL Server Management Studio and connect to the Server.

3. Under Databases, go to the company database, right click and select "New Query".

4. Copy the content of the SQL file into the query.

5. Proceed with the steps provided in the script.





    1. Defines the location where the database backup would be created and stored.
    2. Enter the name of the Database that you would like to backup.
    3. As the Backup will be encrypted, define the Password that will be used to extract the backup.
    4. Enter the path where the 7Zip program is installed.

5. Ensure that the database that you would like to run the backup script on is selected (a) and proceed to Click on the Execute button (b).



This will create the Table, iWoWDB_Backup_Full, under  Databases > 'Company Database' > Programmability > Stored Procedures.


Step 2 - Enable SQL Server Agent

1. Right Click the SQL Server Agent and select Start.



Step 3 - Create New Job

1. Under SQL Server Agent, right click Jobs and select New Job...



2. Configure the New Job according to the Figure shown below. (Note: For Database, Select the database that you are planing to backup)



3. Click on OK


Step 5 - Create New Job Schedule

1. Under SQL Server Agent, go to Jobs and select the Job you had previously created (Eg: BackupDatabase).

2. Click on Schedules.

3. Click on the 'New' button.

4. Configure the schedule for when the backup will occure.Kindly refer to the Figure shown below 



2. Click on OK


    • Related Articles

    • Backup Procedure

      For all outright purchase clients, iWoWHRMS consists of 2 types of important data which required to backup: Upload Data Files: Upload data files refer to the files which uploaded into iWoWHRMS such as photos, attachments, letters and etc. ...
    • Proposed Back Up Plan

      For outright purchased clients, it is advisable to duplicate few backup copies in different location to safeguard data lost. Here are the proposed backup plan for your reference:   Backup has to be performed daily at least. It can be done either by ...
    • 1.2 Multi-User Environment (Server Specification)

      The requirements might change time by time. Hence, it is advisable to confirm with our support team if you need any further clarification on this matter. Storage and Data Management Requirements For optimal performance and data security, the ...
    • 1.1 Single User Environment

      Storage and Data Management Requirements For optimal performance and data security, the following storage setup is required: Database Storage: The MS SQL database must not be stored on the primary system drive (Drive C). This is to avoid potential ...
    • Recommended System Specification

      iWoWSoft HRMS is designed with fully web-based environment and thin client architecture. Most system operations will be processed on the server. It is hence important to ensure the server hardware meet the recommended specification. Numerous factors ...