| Author |
Topic |
|
triton45
Starting Member
16 Posts |
 Posted - 2009-04-06 : 09:33:25
|
| We are evaluating some new shop floor enterprise software (Optivision by Honeywell). One of the databases supported is MS SQL Server.Our current shop floor software runs on IBM Informix. The yearly maintenance fees include 24x7 phone support.Do you manage a 24x7 x 365 environment without support? Are there options available for support? Thanks,Andy |
|
|
triton45
Starting Member
16 Posts |
Posted - 2009-04-15 : 13:38:03
|
| Anyone?What do you do when you have a catastrophic crash or hardware failure? Do you just rely on these forums? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-15 : 13:47:36
|
We rely on our tested backups.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-04-15 : 16:21:05
|
| Personally, I rely on myself a great deal. All you really have to do is think out your backup AND recovery plans. I usually play a game with people coming up with backup/recovery plans. The game is I point to any item, and call it dead. Then you tell me what you do to recover. If you can't come up with anything good enough to satisfy the business' needs, you go back to the drawing board.It's lots of fun, too. I can point at an individual disk, a RAID controller, a network switch, an individual person, even the whole building. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-15 : 16:42:25
|
I think it is the base of everything.You can have support agreements with vendors to change your harddrives or whatever in less than 3 hours, but without a data backup as recent as possible what will you do with your brand new hardware when there is not proper and tested backups to restore?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-04-15 : 16:51:22
|
| It is good to have database support option. But solution is not guranteed at the time of distater. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-04-15 : 16:55:37
|
quote:
Originally posted by Peso
I think it is the base of everything.You can have support agreements with vendors to change your harddrives or whatever in less than 3 hours, but without a data backup as recent as possible what will you do with your brand new hardware when there is not proper and tested backups to restore?
It's the base, but it does not replace support. They are distinct items.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-04-15 : 17:24:38
|
| I have been on call for the past 5 years. Dont know everything but every 14 hour day, gets me a bit closer. |
|
|
|
triton45
Starting Member
16 Posts |
Posted - 2009-04-15 : 18:56:38
|
| I should have been more clear about what kind of support. I was asking specifically about SQL Server support. I am the only dba and would like to take the occasional vacation.Not every problem is resolved by restoring last night's backup and all the logs since. In the last 10 years I have never restored a production database (knock on wood). Thanks for all the repliesAndy |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-04-15 : 19:18:30
|
| I open cases with Microsoft regarding production issues about 5-10 times per year. This has all been for SQL Server support and they were all because we needed help in getting a critical production issue fixed that can not be resolved with a restore. None of them were the types of issues that you can come to a forum for help and then wait for a response, regardless of how fast some topics get answered.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
|
Paid support -- do you have it?