How to manually back up my database

  1. Open SQL Server Management Studio
  2. Log in with your details.  This information should be kept under management.
    • If you need help finding your login details, please contact KAS.
  3. Right-click on the database
    • For LMS Platinum: right click RF2008
    • For Adel: right click Adel
    • For Lock-S: right click KASDB
  4. Select Tasks
  5. Select Back up
  6. Note the Directory Location – In the large white box
    • This is file path you will need to follow to get to the back up later.
  7. Press Ok.
  8. Close SQL
    • Find the back up in your Computer Folders from the directory address that was in the large white box above.
    • Copy this .bak file and keep it safe on another computer or device.
    • You will need this file if your computer ever crashes or is unsalvageable.
    • Ensure you do regular backups

 

Was this article helpful?

Related Articles

Leave A Comment?