Lock-S Software

How To Manually Back Up SQL Database

11 views January 23, 2019 January 23, 2019 lock-s 0

  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.
    • Normally you can just click connection under ‘Windows Authentication’
  3. Right-click on the database “Lock_HR”
  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 Workstation
    • 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 helpful?