How to manually take a database backup

How to manually take a database backup

Instructions

  1. Open SQL Server Management Studio
  2. Login with your details.  This information should be kept upper management.
      3. If you need help finding your login details, please contact contact your IT department
  3. Right-click on the database named "Lock_HRS" or "RF2008" or "A92" (depending on what software you use)
  4. Select Tasks
  5. Select Backup
  6. Note the Directory Location - *In the large white box 
    7. This is file path you will need to follow to get to the back up later.
  7. Press Ok.
  8. Close SQL
  9. Find the backup in your Computer Folders from the directory address that was in the large white box above.
  10. Copy this .bak file and keep it safe on another computer or device.
  11. You will need this file if your computer ever crashes or is unsalvageable.
  12. Ensure you do regular backup

    • Related Articles

    • Download and Install KAS SQL Auto Backup Tool (Windows only)

      KAS SQL Database Backup Tool Please click on the following link to download the KAS Auto Backup Tool:  Download Backup Tool Double click on the KAS Back Tool setup  Click Next Keep clicking Next until you see the following screen and then click ...

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

      These are instructions for a local database, if you are using SQL you will need to use other instructions.  Instructions Close the LMS software You will need to find the database file RFV2008.mdb. There are 2 options to find this Search the PC for ...

    • 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. Prerequisites Main computer fully configured and installed as per the instructions in this ...

    • LMS Software - Installation Setup

      Please Click Here to download and install KAS LMS software If you are Reinstalling the software please backup your database first  After Installing the LMS software, copy the KAS-LMS (patch) file from the above link and paste into the lock software's ...

    • Universal (Adel) Lock - Full Software Manual

      Please click attached file to download.