Lock-S - Backing up your database

Lock-S - Backing up your database

Premise

In the event of a property handover or as part of your backup routines, the Lock-S database can be backed up to prevent a total system lockout.
This ensures that in any event, you will be able to restore your database on a new computer and still issue keys as you normally would.


Alert
Without a backup, in the event of a computer failure, all of your doors will have to be reset with the System Card before they can accept a new Lock-S system installation.
If your computer failed at a point where the System Card does not have the Clear Function enabled, this will require the disassembly of all the locks on your property.
Info
Note: While initial installations are included in the original price, subsequent installations (e.g. secondary computer or re-installation in case of computer failure) will incur a charge as per our IT Services policy.

Backup Steps

This guide assumes that the configuration settings are the default settings as used in the installation guide.

1) Open the SQL Server Management Studio


Default Server Name: LOCALHOST\KASDB
Default Login: sa
Default Password: kas123

2) Locate the Lock_HRS and LockDB_PMS databases


3) Right Click -> Select "Tasks" -> "Backup"


4) Select "Add" and choose the location of where to save the backup to


Ensure you repeat the process for both the Lock_HRS and LockDB_PMS databases.
Notes
Note: You may need to add ".bak" to the end of the file. If it does not appear during restoration, simply rename it and add the ".bak" extension to its name.

5) Once you have saved the files, install Lock-S on your new computer in accordance with the instructions


6) Once all the prerequisite applications are installed on the new computer, open the SQL Management Studio (see: step 1) on the new computer.


7) Right Click "Databases" -> "Restore Database"


8) Select "Device", then the 3 dots ("...") and then "Add"

9) Navigate to the location of your backup file and select it, then click "Ok"


10) The Backup file should appear on the list. Click "Ok".


Notes
Ensure you repeat the process for both "Lock_HRS" and "LockDB_PMS" files.
Alert
! ) If you get an error: Select "Files" and tick "Relocate all files to folder"

11) Backup should be complete and you should have access to all of your previous data in Lock-S. Use your original username and password (default: admin , 123) to login.


    • Related Articles

    • Lock-S - Synchronizing Databases with a second computer

      Premise This guide will provide the basic instructions on how to set up a secondary computer and have it access the same Lock-S database as the main computer. Note: While initial installations are included in the original price, subsequent ...

    • Lock-S Manual / User Guide

      KAS Lock-S Hotel Card Lock Software Module Introduction The KAS Lock-S Software must be activated with Serial number and Product ID. The authorized client must safeguard the unique Product ID assigned. An authorized person should be assigned to take ...

    • How to manually take a database backup

      Instructions Open SQL Server Management Studio Login with your details.  This information should be kept upper management. If you need help finding your login details, please contact contact your IT department Right-click on the database named ...

    • LMS Software - How to take a back up of LMS Database on a local computer

      These are instructions for a local database, not an SQL-based database. Instructions Close the LMS software. Open any folder and navigate to the top address bar. Type "%localappdata%" in it (see image). Navigate to "Virtual Store\Program Files\KAS". ...

    • Lock-S Software - Installing on your Computer

      Step # 1 Ensure that the SQL Server has been installed You must already have installed SQL Server 2012. If you have not done so please click here to complete the steps first Step # 2 Download Lock-S Software Download the zip file in the footer of ...