Advertisement

07.07.2008 at 07:48AM PDT, ID: 23543528 | Points: 500
[x]
Attachment Details

SQL cluster failing at same time diffrent dates

Asked by mhamer in MS SQL Server

we have a long standing sql 200o cluster running on windows 2003  MS cluster
A/A
at 1:26  some mornings the sql service "fails" and the box fails over  but not quite the sql agent doenst make it in one pice so when we get in we need to reboot.

there are many things we have considered but hard to test as this issue may occur twice in a month or not at atll in 40 days.  only factor is 1:26

there is a back up job running  during the fail over  which runs fine when done during the day

looking in to processor times being out

but any other ideas? or even ones that can help woith diagnosing  event viewer not helpful  SQLService Failed"  (yes pf course there are more :-) but nothing i see of causes

  symantec AVStart Free Trial
 
Loading Advertisement...
 
[+][-]07.07.2008 at 08:05AM PDT, ID: 21945683

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.07.2008 at 08:22AM PDT, ID: 21945856

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.08.2008 at 01:51AM PDT, ID: 21951986

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.05.2008 at 07:46AM PDT, ID: 22161423

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628