Backup Procedure

Backup Procedure

For all outright purchase clients, iWoWHRMS consists of 2 types of important data which required to backup:
  1. Upload Data Files: Upload data files refer to the files which uploaded into iWoWHRMS such as photos, attachments, letters and etc.
  2. Database: Database refers to the collection of data which updated into iWoWHRMS. The database used by iWoWHRMS is Microsoft SQL Server.


A daily backup of data files and database is required. Unexpected things can be happen, so a backup for HRMS data is crucial. It is advisable to perform the backup of iWoWHRMS application and database from your server to external hard disk or cloud. As the installation of iWoWHRMS may differently from individual server, here are the guidelines for your reference to identify the folder location of iWoWHRMS and scheduler SQL Server backup. 

Backup iWoWHRMS Installed Folder:

In order for you to know the location folder of the iWoWHRMS has been installed, you are able to check it from the IIS and please refer to the steps below:



  1. Open the IIS Manager. 
  2. Expand the Sites and Default Web Site.
  3. Right click on iWoWHR and click on Explore. 


  4.  Backup is required for iWoWHR folder. 


Schedule and automate backup of iWoWHRMS SQL Database:

There are different methods used to schedule and automate backup for SQL Server Express and SQL Server Standard. Please refers to below:

SQL Server Express

Due to SQL Server Express do not provide the SQL tools, thus it required to write scripts to schedule and automate the backup. There are few steps to back up the iWoWHRMS SQL database by using SQL stored procedure and Windows Task Scheduler. For the detail steps, please refer to http://support.microsoft.com/kb/2019698. 


SQL Server Standard

SQL Server Standard provides the wizards in SQL tools which ease the automation of database backup. For details, please refer to http://technet.microsoft.com/en-us/library/ms191239(v=sql.105).aspx. 

 


Note: It is advisable to backup the database and files onto different media such as an external hard disk or cloud. 


You may also refer to our proposed backup plan at below link:

https://support.iwowsoft.com/portal/kb/articles/proposed-back-up-plan


    • Related Articles

    • 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 ...

    • 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 ...

    • 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 ...

    • 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 ...

    • 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 ...