| Subject: | LinkWEB Backup Database Management |
| Summary: | Add the ability to take backups to allow functionality transfer from Backoffice. Payroll users currently have the ability to take backups, however, there is no visibility on what backups have been completed and how they can be managed. To improve this functionality, we have agreed on the following design: - Add a maintenance form to allow users to create backups
- A background process will perform the backup as some backups may take long
- A status on the backup entry will show what backups have been done
- User has the ability to see backups and maintain them
- Some backups may take some time, therefore users need to be aware that until the status is "Completed", the backup will not be usable
- Row-color: RED (incomplete backups) Black (Completed Backups) Grey (Expired Backups)
|
| Audit Notes: | Edited by sanjay on 11/09/19 09:13. |
| 04 Jun 2019 | 03:58PM Comment 1 by Sanjay (Link Technologies) Case 10439 added to project 11.0 |
| 11 Jun 2019 | 01:56PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 11-06-2019 01:56 PM Time Taken: 25.50 |
| Development work for this case has been completed. The change will be available in version: 11.0.20190611 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Add a maintenance form to allow users to create backups
- A background process will perform the backup as some backups may take longer. Process ID was SYS001
- A status on the backup entry will show what backups have been done
- User has the ability to see backups and maintain them
- Some backups may take some time, therefore users need to be aware that until the status is "Completed", the backup will not be usable
- Row-color: RED (incomplete backups) Black (Completed Backups) Grey (Deleted)
- The backup path will be the SQL Server default path
- All backups including payroll automated backups (Pay Update) will be shown here
2. The issue was caused by: - Improvement
3. Next Step: - UAT
|
|
| 01 Jul 2019 | 09:18AM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 01-07-2019 09:18 AM Time Taken: 2.50 |
| QA Results Tests carried out according to requirements specified on the case header Test Results Summary Table 1 - Summarised list of issues | No | Test Description | Pass/Fail | | 1 | Users with access should be able to create a backup under "Global Administration - Database Backup" | Pass | | 2 | Add a new "Backup" description and "Retention Days" , the backup - "Server", "Database" and "File" path should be updated
| Pass | | 3 | Process SYS001, should execute and create the backup. Review event log for error | Pass | | 4 | The backup "completed" should have black font color. | Pass | | 5 | Incomplete backups should have red font color | Pass | | 6 | Validate that menu 241 has been removed from Backoffice | Pass |
Environment Details - OS version: Windows Server 2012
- Application version: 11.0.0628 BETA
- Setup: Demo
- Server : 10.0.0.14
- Database: LINKSOFT-DEMO-11-RASHNA
Next Step: Documentation
|
|
| 11 Sep 2019 | 09:13AM Comment 4 by Sanjay (Link Technologies) Case 10439 removed from project 11.00 |
| 11 Sep 2019 | 09:13AM Comment 5 by Sanjay (Link Technologies) Case 10439 added to project 11.00 |
| 19 Sep 2019 | 10:32AM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 19-09-2019 10:32 AM Time Taken: 1.00 |
| Hi Sanjay, Documentation has been updated at this link. Thanks
Rashna |
|