November 27, 2013 at 6:26 am
Ed Wagner (11/27/2013)
GilaMonster (11/27/2013)
Anyone want to handle this one?'A server which sends custom alerts is sending notifications that an offline database is offline. Why would it do that?'
http://www.sqlservercentral.com/Forums/Topic1518022-146-1.aspx
I offered up the system Performance Logs and Alerts, but I have no idea if this is it. Could be a database job or scheduled task, but how would a query be aware of a database that's offline? After all, it's offline.
A query against sys.databases could be aware, it could check the status column, see if any DBs have been set to offline, but if so, that'll be custom code/job
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2013 at 6:30 am
Greg, thanks for the suggestion, thankfully the method of "upgrading" here is to deploy a new server, clean-loaded with the new OS. I think what's potentially going on is the VMDK file(s) may either be corrupt, or the physical storage they're on has a problem. Either way, the server in question for that should be getting turned off next week.
Revenant, I don't drink, but a good recommendation for a decent beer might help... Or a box of 100rds 9mm FMJ ammo so I can go to the range after work and pretend the targets are the people I was complaining about...
:w00t:
Maybe even spring for silouhette targets and tape pictures of the faces to them...
😉
Thankfully, my direct superiors are working to avert a disconnection of the servers in question, so hopefully I won't be facing hordes of angry users before the end of the day...
November 27, 2013 at 7:19 am
jasona.work (11/27/2013)
Greg, thanks for the suggestion, thankfully the method of "upgrading" here is to deploy a new server, clean-loaded with the new OS. I think what's potentially going on is the VMDK file(s) may either be corrupt, or the physical storage they're on has a problem. Either way, the server in question for that should be getting turned off next week.Revenant, I don't drink, but a good recommendation for a decent beer might help... Or a box of 100rds 9mm FMJ ammo so I can go to the range after work and pretend the targets are the people I was complaining about...
:w00t:
Maybe even spring for silouhette targets and tape pictures of the faces to them...
😉
Thankfully, my direct superiors are working to avert a disconnection of the servers in question, so hopefully I won't be facing hordes of angry users before the end of the day...
It's up and running now, so I wouldn't think the physical storage is the issue.
Dig just a bit further into how the current one is configured vs. the cleanly deployed one might lead to a quick answer.
With the price and availability of ammo, you might run into cost and time delays.
Be cautious shooting custom silouhettes. Kind of raises red flags.
So Castle Danger has a couple good beers.
But they are only open 3pm to 8pm Friday and Saturday, and location on the north shore of Lake Superior might be problems.
Finding a local brew pub sounds like a better idea.
November 27, 2013 at 7:50 am
Greg Edwards-268690 (11/23/2013)
L' Eomot Inversé (11/23/2013)
Ed Wagner (11/22/2013)
I never had the "pleasure" of working with either of those IBM products, but I've been forced to work with other ones. If they're any judge, it's a wonder the company is still in business.That sounds as if you worked with DB2 and SNA. Or did they have another two that bad?
DB2 on an AS400 was pretty rock solid. I kind of wished SQL Server ran on an AS400.
I think if some places added up the total costs, they might think twice about Windows Servers.
I can atest to that. They take a lickin' and keep on tickin'. The only time they don't is when the battery on cache runs dry. Then, it's a world of hurt performane wise and you have to re-convince people that the system has a bloody battery in it. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2013 at 7:52 am
jasona.work (11/26/2013)
/rant mode onFrickin' bloody pain in the tuckus idiotic mindless rules drones! Gotta go in early tomorrow because it's entirely possible a SQL server and a couple Oracle servers I've been baby-sitting for a couple months may get pulled from the network because they're not "updated." Let's see, a SQL server that is required to go away by Monday because it's running Win Server 2008 and not 2008R2 that when I tried to update it lost several drives after the reboot (VM, so I was able to revert to the snapshot from before doing anything,) and Oracle databases that are in a:
"You need to patch for this vulnerability.
There's no patch from Oracle for the version being run for that vulnerability and there's no Oracle DBA to handle upgrading.
You need to patch for this vulnerability.
See my previous response.
You need to patch for this vulnerability or upgrade.
See my previous response.
We're threatening to pull these servers from the network if you don't apply the patch.
THERE IS NO D*MN PATCH FOR WHAT YOU WANT!!!!"
So now I get to go in early, potentially to explain to the customers why stuff isn't working, where my only answer can be "IA pulled them because there's no patch to fix what they want fixed from the vendor, or "fixing" the problem breaks the server anyways."
yay
/rant off
So, hope everyone has a happy Thanksgiving if you celebrate it, or a nice weekend otherwise!
Document the problem, save all emails, forward to the CEO, and enjoy your ThanksGiving off.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 27, 2013 at 4:49 pm
Jeff Moden (11/27/2013)
Document the problem, save all emails, forward to the CEO, and enjoy your ThanksGiving off.
Thankfully my boss has been involved from nearly the start and knows what's been going on. Plus he gets CC'ed on the e-mails about it.
But what a day...
So, the servers didn't get taken off the network, so that's a plus. But, the SQL server that was giving me problems did restart last night, when the VMWare host it was on failed. So wound up taking a snapshot before doing anything, then trying to straighten out the problem. Chkdsk did report problems, but once I assigned permissions to the drives and folders, managed to get (most) of the Sharepoint DBs up.
The two that didn't come back we restored from last nights backup and all was well. The Sharepoint Admin sorted out an issue he had been having, and we're go to switch to the new SQL and SP servers next week. The SP guys want to hold off until Thursday to do the switch so as to not have to deal with users having fits because SP is down. I had the backup admin (Commvault handles the backups, does "normal" SQL backups) bump up the frequency of TLog backups to cut down on potential data loss if the SQL server dies before then...
Then I went to the gun range and burned some frustration on paper targets...
😎
November 27, 2013 at 6:07 pm
jasona.work (11/27/2013)
Jeff Moden (11/27/2013)
Document the problem, save all emails, forward to the CEO, and enjoy your ThanksGiving off.Thankfully my boss has been involved from nearly the start and knows what's been going on. Plus he gets CC'ed on the e-mails about it.
But what a day...
So, the servers didn't get taken off the network, so that's a plus. But, the SQL server that was giving me problems did restart last night, when the VMWare host it was on failed. So wound up taking a snapshot before doing anything, then trying to straighten out the problem. Chkdsk did report problems, but once I assigned permissions to the drives and folders, managed to get (most) of the Sharepoint DBs up.
The two that didn't come back we restored from last nights backup and all was well. The Sharepoint Admin sorted out an issue he had been having, and we're go to switch to the new SQL and SP servers next week. The SP guys want to hold off until Thursday to do the switch so as to not have to deal with users having fits because SP is down. I had the backup admin (Commvault handles the backups, does "normal" SQL backups) bump up the frequency of TLog backups to cut down on potential data loss if the SQL server dies before then...
Then I went to the gun range and burned some frustration on paper targets...
😎
Good to hear they're back and online. At least you got to have some fun. Enjoy your Thanksgiving off and don't forget to eat too much. 😀
November 28, 2013 at 1:50 pm
Hope everyone is enjoying the holiday in the US, or having a good day elsewhere.
November 28, 2013 at 2:02 pm
Steve Jones - SSC Editor (11/28/2013)
Hope everyone is enjoying the holiday in the US, or having a good day elsewhere.
You bet your a**. Once again, Steve, I do appreciate your work. whatever I can do for you.
November 28, 2013 at 6:08 pm
Revenant (11/28/2013)
Steve Jones - SSC Editor (11/28/2013)
Hope everyone is enjoying the holiday in the US, or having a good day elsewhere.You bet your a**. Once again, Steve, I do appreciate your work. whatever I can do for you.
You too, Steve. The food, clean-up and visiting are done. Now for the food coma. I'll wait a while before the snack. 😀
November 28, 2013 at 7:38 pm
Turkey and Nap go together very well.
Sad that some stores are starting Black Friday early.
Hope everyone had a great day, both here and abroad.
November 29, 2013 at 4:09 pm
Happy Holidays to all
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 30, 2013 at 5:56 pm
Thanks and a good holiday here. Quiet, with family.
Personally I have no issue with stores opening on Thanksgiving. The first time I worked on the holiday was when I was 12. Spent the next 10-15 years working on that day before I was senior enough to avoid it.
Some people want to work, some need the money, and some work because they're needed.
November 30, 2013 at 6:55 pm
Steve Jones - SSC Editor (11/30/2013)
Thanks and a good holiday here. Quiet, with family.Personally I have no issue with stores opening on Thanksgiving. The first time I worked on the holiday was when I was 12. Spent the next 10-15 years working on that day before I was senior enough to avoid it.
Some people want to work, some need the money, and some work because they're needed.
... and some people just have to check the daily ingestion because no one else will do it. 😉
December 1, 2013 at 2:59 am
Revenant (11/30/2013)
Steve Jones - SSC Editor (11/30/2013)
Thanks and a good holiday here. Quiet, with family.Personally I have no issue with stores opening on Thanksgiving. The first time I worked on the holiday was when I was 12. Spent the next 10-15 years working on that day before I was senior enough to avoid it.
Some people want to work, some need the money, and some work because they're needed.
... and some people just have to check the daily ingestion because no one else will do it. 😉
And some of us work because there is nothing else to do but work.
Actually, Thanksgiving Day was spent in-transit from ISAF HQ to Bagram. We had a non-traditional Thanksgiving Dinner which consisted of Thai food (I had the Crying Tiger).
We are now all working at Bagram after being evicted from ISAF so units moving from Eggers (which was shutting down) had a place to go.
I will say that the food at the DFAC here is SO much better than that served at ISAF.
Viewing 15 posts - 42,241 through 42,255 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply