SQL-database-support-ERP-systemIt’s easy to forget about the database sitting behind your Business Application, the users only ever see the “front end”, and they will perhaps only think of the storage if things slow down or worse still, stop functioning altogether. The management and monitoring of the “back end” or database is often overlooked by businesses until it is too late. According to London Chamber of Commerce 90% of businesses that lose data from a disaster are forced to shut down within 2 years of the disaster!

SQL server maintenance and regular backups is a necessity and not a luxury for businesses. SQL maintenance is not ‘insurance’ type maintenance - taken out in case something goes wrong. It is not a reactive service which customers may never need. SQL server database is a complex matrix of ever growing files, data, logs, tables, indexes, statistics, transactions and sub-tables. If an active server database is not being monitored and backed up properly – something will go wrong. Proactive monitoring early in the life of the SQL server pre-empts expensive ‘fixes’ later and the likelihood of disastrous problems.

Here are some interesting statistics* which highlights the importance of database maintenance and support:

  • 90% of businesses that lose data from a disaster are forced to shut down within 2 years of the disaster.
  • 50% of businesses experiencing a computer outage will be forced to shut within 5 years.

Our question to you: Have you recently checked with IT if they are looking after your SQL database? How about a surprise request to test restore last night’s data?

To find out more about, visit: www.advantage.co.uk