Canada | English Locations

855.558.3856 Start Your Data Recovery
855.558.3856
855.558.3856
Start Your Data Recovery

Another dropped table? SQL DBA to the rescue!

Written By: Ontrack

Date Published: September 06, 2022

Another dropped table? SQL DBA to the rescue!

Arrow Left Back to listing

Anyone in an IT role has two kinds of work days. Good days are defined by no one bothering them and they get to work on the strategic business initiatives they’ve been assigned to enhance the functioning of their business. Bad days are plagued with a long list of interruptions in the form of “tickets” or requests from development, legal or other departments that urgently require your genius to get them back up and running. Every good Database Administrator (DBA) has far more bad days than good because SQL table/row restores are a weekly, if not daily occurrence.

Why does this happen? The reasons are countless… The finance team started using the wrong currency or conversion rate on a report at some point and needs to get it corrected. A developer deleted a table. During a routine update of the business system, an admin deleted rows they thought weren’t important – turns out they were used by many other tables and caused the system to fail. The list goes on and on.

Once a problem is identified, you are called to resolve the issue. I bet your approach goes a little something like this… First, you determine when in time the data was good. Next, you find a backup that contains the database with the table(s) with the “good” data. The full database will need to be restored. This process requires finding a SQL server and sufficient storage space. Restoring a database can take many minutes, but you know all too well that this often takes an hour or many hours depending on the size of the database. The process requires frequent monitoring and you cost a lot per hour! After the database has been restored, you examine it to determine if the desired table is present. If not, you continue restoring databases until the table is found right? Once the desired table has been found, you copy it to the production environment using scripts. And when a critical revenue application is down, all of this is happening with the CIO standing behind you looking over your shoulder.

Are you tired yet? I am. We are interested in learning more about how often this happens to you. Share your experience by taking this short poll: .

Subscribe

Related Topics

Lost in the Cloud: Steps to Protect Your Cloud Data

The Challenges in Data Recovery Today

Is data recovery the same as storage repair?
Services
Products
Resources
About

KLDiscovery Ontrack Canada Co, 155 Gordon Baker Rd Suite 100, North York, M2H 3N7, Canada (see all locations)

© 2024 KLDiscovery Ontrack - All Rights Reserved.