- Open SQL Server Management Studio
-
- 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’
- Right-click on the database “Lock_HR”
- Select Tasks
- Select Back up
- 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.
- Press Ok.
- 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