Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2006-12-30 : 09:39:17
|
| I have SQL Server 2000 SP4Cluster Services running data on SANI have two groups SQL1 owner SQLCL1, SQL2 owner SQLCL2Active resources SQLCL1 owner SQLCL1 group SQL1 SQLCL2 ower SQLCL2 group SQL2Every 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 |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2006-12-30 : 15:15:23
|
| Do you find any error/warning in SQL error log OR Application/System log?---------------------------Sandesh - The Messenger |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2006-12-30 : 16:15:36
|
| Nothing in event logs nothing in sql logs its almost like someone is doing it at 1:30 every other friday.SQL Services switch to 2nd node......everything carries on like normal a few processes get disconnected during the carry over and SQL Server shutdowns giving SQL Server the normal events it does on a shutdown.I check the error logs, event logs, sql logs im almost thinking there is some setting in the cluster that you can put on a timer to say in x days switch over like a testing phrase perhaps...but can't find any info on it.I know to take lunch at 1:30 lol |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2006-12-30 : 16:52:58
|
| Just found this 1:17 and then at 1:30 system reboots....The system failed to register host (A) resource records (RRs) for network adapterwith 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 DNSBut it happens every 2nd friday 1:30 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-30 : 16:59:49
|
| Wild guess: Some sort of lease expiring?Kristen |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2006-12-31 : 09:12:48
|
| Lease expiring on what service software? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-31 : 09:16:03
|
| I was meaning on a DNS result - like an IP address lease or somesuch.Kristen |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2006-12-31 : 10:00:10
|
| Thanks we own our own DNS servers....but i think it has something to do with the DNS ttl as the information in logs is pointing this way and i cannot find anything in SQL that causes the sql server to shutdown.However ....if i think about it and its the DNS SQL cluster cannot resolve name and then move the services over...im now thinking why sql shutdown perhaps this is part of the SQL Cluster when it moves over services it does a shutdown i have to investigate this part. |
|
|
|
|
|
|
SQL Cluster fails