How Database is important for my business?
The database is very sensitive and very important as all information related to our software are saved there, SQL databases are subject to occasional corruption issues, but these can be minimized with careful management.
What are the causes of corruption?
There are many ways a database can be corrupted. Some are user-related like below:
Rebooting or switching off PC when server or clients are open
PC crashing (freezing) when server and clients are open
Sometimes hardware and/or unhealthy IT environment are the causes such as:
Harddisk error
Network error or failure
Power loss
Virus issues
OS related issues. etc.
How can I prevent this?
Have a proper power back up with UPS
Shutdown all systems safely
- Close applications in Clients first [If exist] and shutdown the clients
- Close it in Server @ last
- Shutdown the server system
- Have anti virus software in all systems and enable firewall in all machines
- Take database backup in external media (i.e.. CD/RW, Flash drive, Cloud (Google Drive / Dropbox))
- Verify the Network connections regularly, Data loss must be 0 in network ping
- Use CHKDSK [Check disk] tool monthly once
- My computer – Select the drive and right click – Properties – Goto Tools tab – Click Check now button
- Always exit the database or application correctly and avoid using Alt+Ctrl+Delete / Task manager to terminate the application or database
- Do periodic health check [maintenance] for your computer with the help of your hardware specialists
- Troubleshoot if improperly disconnected from network
Note: GOFRUGAL shall not be liable for service or support for problems arising out of the computer hardware and others not related to ERP solution.
Please take a step ahead in following the instructions listed above to overcome data loss. In most cases, we will have to go with restoring the last successful backup only. Help us & Help you.