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 "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