Link to home
Create AccountLog in
Avatar of Pau Lo
Pau Lo

asked on

Application backups

Can I ask a very novice question re backups from a low tech management standpoint. Say for example we have a payroll application that we host ourselves, and the data that drives the application is stored in a MS-SQL 2008 database.

1. If we ask our IT for assurances the “application” is backed up, and they say they only back the database up. Is that potentially an issue? What on the “application” side is normally backed up, in a typical business application? I appreciate this may differ from app to app but in general….

2. Is it more common you restore a backup of the database, as opposed the application?

3. What exactly will you be backing up re the application as opposed the database, and is it important to do?

4. Can you give examples where’d you need to restore the application backup, as opposed the database? What can go wrong where you need to backup whatever files relate to the app?

5. What’s the risk in ONLY backing up the apps database, as opposed to whatever needs backing up re the app?
ASKER CERTIFIED SOLUTION
Avatar of symbiont_it
symbiont_it

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Pau Lo
Pau Lo

ASKER

Ok thanks - how would an app get corrupt and is it common? Is it common for a db to go corrupt out if interest?
There are several ways that application files can get corrupt.  There could be bad blocks on the drive itself that corrupt files.  Mal-ware could damage the application.  There could be an error in an update/upgrade that damages a file.  Application corruption is less common that data loss or data corruption.  Normally for a file to be corrupt there needs to be change made to the file and application files just don't change that much unless your speaking of an upgrade/update.

DB corruption is common enough that as an admin you have seen it in your day and you protect from it with a backup.  It ranges from application to application.  I have had newly released applications have constant data corruption and I have had applications that I have never dealt with corruption at all.  A properly written application you may deal with it once in a five year period.  But when that once happens you better have a way to recover from it.  You are actually more likely to suffer from data loss before you deal with corruption and that normally happens on the end-user side.

~Symbiont_IT
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account