Back to knowledgebase
17 Jun 2019
1 min read
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 ...
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 "Lock_HRS" or "RF2008" or "A92" (depending on what software you use)
- Select Tasks
- Select Backup
- 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
- Find the backup 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 backup