Have you ever had that sinking feeling in your stomach when you realize your data has become corrupt, and you must now perform a restore from your database backup…wait, what backup?? The only time you recall backing up was in your car when you left your house this morning.
Picture this: You finally decide to take a vacation, so you have left your database running in the good hands of your co-workers. Just as you sit back in your lounge chair on the beach, your cell phone rings. The disk drive has crashed, and even though you have performed scheduled backups, you aren’t in the office to actually perform this urgent restore, and only you know the steps to take. This can mean only one thing: manually walking your co-workers through a database restore process over a costly phone call, thousands of miles away, while your vacation time quickly slips by, …oh the dread.
Hello, this is Elaine, a Support Analyst within the Geodata unit at ESRI Support Services located in Charlotte, NC. I have been with ESRI for almost nine years working as an Instructor and Technical Analyst within ESRI’s Professional Services division and now as a Support Analyst within ESRI’s Support Services. Over the years, I have heard of many stomach-wrenching scenarios from clients who have run into various backup and restore situations such as the ones listed above, and I have a few tips that I would like to pass on to you to in order to be prepared!
SQL Server:
•SQL Server backups
•Recovery models for SQL Server
ORACLE:
•Oracle backups
•Recovery models for Oracle
DB2:
•DB2 backups
•Recovery models for DB2
Informix:
•Informix backups
•Recovery models for Informix
PostgreSQL:
•PostgreSQL backups
•Recovery models for PostgreSQL
Knowing that you have already accounted for every possible step and potential question, you can quickly get back to soaking up the sun on your lounge chair on the beach!
- Elaine E., Support Analyst - Geodata Unit, ESRI Support Services, Charlotte, NC.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.