cluster fails
-
I have SQL Server 2000 SP4
Cluster Services running data on SAN
I have two groups SQL1 owner SQLCL1, SQL2 owner SQLCL2
Active resources
SQLCL1 owner SQLCL1 group SQL1
SQLCL2 ower SQLCL2 group SQL2
Every 2 weeks at 1:30 on a friday of all days The active resources for SQL1CL1 switch to SQLCL2 so under active resources i have all of SQL1 in there.
I then decided to flip flop everything SQL1 to SQLCL2
Then again 2 weeks later again SQL1 fails over .....
I cannot figure out why that every 2 weeks this is failing over to the other nodes.
Any advice is appreciated
-
i would suspect something shutting the service down - look for a sheduled job in sql agent or windows sheduled tasks that does something along the lines of
xp_cmdshell 'net stop mssqlserver'
MVDBA
-
Nothing in the jobs or agents at all
Nothing in the event logs.....its almost like a manual process someones comes along and moves the groups over and shuts the sql down.
-
Just found this 1:17 and then at 1:30 system reboots....
The system failed to register host (A) resource records (RRs) for network adapter
with settings:
The reason the system could not register these RRs was because of a security related problem. The cause of this could be (a) your computer does not have permissions to register and update the specific DNS domain name set for this adapter, or (b) there might have been a problem negotiating valid credentials with the DNS server during the processing of the update request.
You can manually retry DNS registration of the network adapter and its settings by typing "ipconfig /registerdns" at the command prompt. If problems still persist, contact your DNS server or network systems administrator. For specific error code, see the record data displayed below.
hmm is it something with the DNS
But it happens every 2nd friday 1:30
-
does your DNS server/PDC reboot at any point?
MVDBA
-
im looking now at DNS and see if anything thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply