|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Friday, May 24, 2013 1:48 AM
Points: 8,
Visits: 59
|
|
Hi all
In our company we take turns to be on support, we generally have 3 x support phones, one on each network, and we get notified via sms depending on what is down. We do check each system where applicable by using the phones ussd short cuts, for some of our applications and in general, it is just to monitor the system. Each system will restart itself in the event of a connectio issue and sometimes we need to restart a specific tasks/job via dial up connection using VPN.
The support rota works nice as you end up learning more about everyone else’s jobs as well, and you do not have to be on duty 24/7, only once every other week. And in general you could plan ahead when going away or so.
Groete Pierré
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Thursday, February 14, 2013 7:06 AM
Points: 1,
Visits: 48
|
|
| Most of the databases I administer run well without much intervention. Typically when there is an issue I am called on my cell and I RDP via a VPN portal into either my desktop PC or directly to the SQL server and resolve the issue.
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 9:12 AM
Points: 1,167,
Visits: 646
|
|
| The only time I was called on, I had to spend 2 hours on my cell phone.
|
|
|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Today @ 1:59 PM
Points: 402,
Visits: 489
|
|
| Usually someone calls me. Most of the time I can use the remote desktop, very occasionally I have to drive in(14 miles if I'm in town.) If a PC is handy, I prefer that. I can remote access on my android, but it is annoying to scroll around the screen to find things.
|
|
|
|
|
SSC-Dedicated
           
Group: Administrators
Last Login: Today @ 3:19 PM
Points: 31,526,
Visits: 13,863
|
|
For me, email is really the way I hear about things. I have a smartphone, iPad, and multiple machines. On one of those, I'll get a note. It could be a phone call, but that's rare.
From there I might call or forward the notice to someone else, or possibly connect with VPN. I might even call and be remote hands for someone if that's quicker.
Getting work when you aren't at work is a reality, but it doesn't have to mean you work 40+ hours and then respond to things. I would definitely set boundaries and push back to get time back, and better balance in your life.
Follow me on Twitter: @way0utwest
 Forum Etiquette: How to post data/code on a forum to get the best help
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Today @ 6:32 AM
Points: 2,229,
Visits: 2,086
|
|
Usually I'll get a system or operator generated email and/or page. I'll connect using desptop or laptop VPN/RDP connection to my work desktop or directly to server. Have talked somebody through something once or twice. Have never had to drive into office to take care of an issue. Have reinstalled SQL Server a couple of time remotely with no problems.
Mike
_____________________________________________________________________________
A word to the wise ain't necessary, it's the stupid ones who need the advice ...Bill Cosby
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:08 PM
Points: 175,
Visits: 719
|
|
In case you might like an free iPad to help remotely monitor your SQL Servers, 30 iPads are being given away by three DBAs, along with 30 free licenses to Red Gate's SQL Monitor. Check out these links:
http://www.sqlservercentral.com/articles/Editorial/71830/ http://scarydba.com/ http://www.brentozar.com/
Hurry to enter to win one of these iPads, as the contest ends this Friday. I wish I could enter the contest, but I am not eligible.
Brad M. McGehee Microsoft SQL Server MVP Director of DBA Education, Red Gate Software www.bradmcgehee.com
|
|
|
|
|
SSCoach
         
Group: General Forum Members
Last Login: Today @ 5:03 PM
Points: 18,853,
Visits: 12,438
|
|
when you are away from work and a database-related problem occurs, how are you generally notified?
First notification is via email. Then it progresses to phone calls if the email is not noticed.
Secondly, once you’ve been alerted, how do you generally connect to your servers to see what is going on? Do you use a smartphone, a tablet computer, a netbook/laptop/desktop computer?
I connect via VPN from laptop.
And third, how often can you typically resolve the problem remotely, and how often do you still have to come into the office to fix things?
90% of the time it can be fixed remotely.
Jason AKA CirqueDeSQLeil I have given a name to my pain... MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw Posting Data Etiquette - Jeff Moden Hidden RBAR - Jeff Moden VLFs and the Tran Log - Kimberly Tripp
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:53 AM
Points: 1,
Visits: 15
|
|
Fortunately I haven't had to respond after hours to a SQL emergency. I have email messages sent when SQL Agent jobs go wrong. Its nice that I don't have to carry a pager or work phone anymore!
If I do need to work after hours I can login from home using a VPN connection to my computer back at work. I can then operate as if I were at my desk.
|
|
|
|