View unanswered posts | View active topics It is currently Wed Jun 28, 2017 5:07 pm



Reply to topic  [ 7 posts ] 
sigh 
Author Message

Joined: Mon May 24, 2010 2:20 am
Posts: 1085
Post sigh
As a lead for a second level support desk, once in a while i need to watch the queues and maybe hop in if the wait times are bad....phones were busy this morning, so I hopped in, and ended up taking a call from a high profile client. This was their second call since late yesterday. Yesterday, we quickly identified they're issue with our software to be a corrupted SQL database. We offered some guidance on attempting to repair, and agreed if that didn't work, they needed to restore a backup as they had one from 5 hours prior to things going south.

They called in this morning, after attempting the repair, and provided DBCC results. I looked over this, and this time, unlike some of their past cases, the errors weren't pointing to corrupted indexes we could simply drop and rebuild, but rather fully loaded with really bad errors, I'm not DBA, but I know this, because a quick google search of these provided an abundant number of responses saying "please god tell us you have a backup". Not wanting to waste their time grinding the wheels to know where, I told them in the nicest way possible that they need to restore from backup, and recommended doing a dbcc check after the restoration to make sure the backup is good in case this has been creeping in for a while. I've repaired their database before and made recommendations for backup practices and doing periodic checks on their 400gb database. It is apparent they did not follow any of these recommendations.

Instead, they emailed their sales rep, with something like the following

We’ve run into a situation again where we’ve been told by tech support that our database has “too much corruption to repair and we should restore the database from backup”. This has happened at least 2 or 3 times in recent memory, and it’s very frustrating. Our software has been down for two days now. Certainly there has to be an answer to this other than restoring the database from backup each time.

dafuq....seriously, I'm sorry, but if a database keeps getting corrupted, wtf are you doing? we have customers with DB's over 2Tb that don't have these types of problems on a regular basis.

_________________
Main System: Intel i7 2600K | Asus P8Z68 Deluxe Gen3 | 16gb Corsair 1600Mhz | Zotac GTX660 Ti | 128gb OCZ Agility 4 | 1tb WD Black | Corsair HX850 | FD Arc Midi | Mac OS X 10.8.5
Gaming Rig: Intel i7 3930K | Asus Sabertooth X79 | 32gb Kingston HyperX 1866Mhz | 2x EVGA GTX780 SC ACX | 2x Mushkin 60gb SSD (RAID0) | 2tb WD Black | Corsair AX1200i | FD Arc Midi | Windows 8
HTPC: AMD A10-6800K | Asus F2A85-M Pro | 8gb Corsair 1866Mhz | 2x 256Gb Samsung 840 Pro | Antec MicroFusion | Windows 8.1


Fri Jul 17, 2015 3:41 pm
Profile
Site Moderator
User avatar

Joined: Sat May 22, 2010 12:07 pm
Posts: 3667
Location: Dallas, Texas, U.S.
Post Re: sigh
When I used to have days like that at work.
After work i would just go "where everybody knows your name".


Wed Jul 22, 2015 1:23 pm
Profile ICQ

Joined: Fri May 23, 2014 5:27 pm
Posts: 5
Post Re: sigh
Get shitfaced, go to work. Problem(s) solved.


Wed Aug 05, 2015 8:01 am
Profile
Site Moderator
User avatar

Joined: Sat May 22, 2010 12:07 pm
Posts: 3667
Location: Dallas, Texas, U.S.
Post Re: sigh
NovaWTF wrote:
Get shitfaced, go to work. Problem(s) solved.


Do I know you? Arent you the 3rd one from the left?

Image


Wed Aug 05, 2015 4:28 pm
Profile ICQ

Joined: Fri May 23, 2014 5:27 pm
Posts: 5
Post Re: sigh
Comixion wrote:
NovaWTF wrote:
Get shitfaced, go to work. Problem(s) solved.


Do I know you? Arent you the 3rd one from the left?

Image


I seem to have gotten lost, what is this place?


Thu Aug 06, 2015 2:40 pm
Profile
Site Moderator
User avatar

Joined: Sat May 22, 2010 12:07 pm
Posts: 3667
Location: Dallas, Texas, U.S.
Post Re: sigh
Use a GPS like everyone else.

This is the place where dreams are made.
Albeit nightmares on occasion.


Fri Aug 07, 2015 11:23 am
Profile ICQ

Joined: Mon May 24, 2010 2:20 am
Posts: 1085
Post Re: sigh
NovaWTF wrote:
Get shitfaced, go to work. Problem(s) solved.

LOL, I wish. If I could maintain an 6-8 beer blood alcohol level throughout the day, I'd be a much happier person

_________________
Main System: Intel i7 2600K | Asus P8Z68 Deluxe Gen3 | 16gb Corsair 1600Mhz | Zotac GTX660 Ti | 128gb OCZ Agility 4 | 1tb WD Black | Corsair HX850 | FD Arc Midi | Mac OS X 10.8.5
Gaming Rig: Intel i7 3930K | Asus Sabertooth X79 | 32gb Kingston HyperX 1866Mhz | 2x EVGA GTX780 SC ACX | 2x Mushkin 60gb SSD (RAID0) | 2tb WD Black | Corsair AX1200i | FD Arc Midi | Windows 8
HTPC: AMD A10-6800K | Asus F2A85-M Pro | 8gb Corsair 1866Mhz | 2x 256Gb Samsung 840 Pro | Antec MicroFusion | Windows 8.1


Fri Aug 21, 2015 3:38 pm
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 7 posts ] 

Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Theme Designed by ST Software for PTF.