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 |
|
maramor
Starting Member
18 Posts |
 Posted - 2009-03-09 : 09:40:00
|
 OK this could be in the new to SQL forums section but this fits here better.I have been working with SQL now for 2-3 months and I am now the DBA. I am getting caught up on everything going on. We have a SQL 2005 x64bit Cluster. I have been to a bunch of training but none of them really talked about cluster databases. The cluster rolled over and I don't know why. I am leaning towards IO as these were the last alerts SQL spit out prior to failover but we are on a SAN and the network guys say impossable :) they always do.With that said, on the fail over box, I don't have Management Studio and the machine really does not know that SQL is installed and running. Is this the nature of the fail over box? We have a SAN snapshot app via NetApp and it does not see it. Perhaps the failover box is just holding while the main one gets checked? Any standard things to check?It is up and running and I can connect from remote location. The main box has Management Studio. The biggest issues are that I am no longer getting Job Notifications and SAN SnapShots.Thanks,Matt |
|
|
guptam
Posting Yak Master
161 Posts |
Posted - 2009-03-09 : 18:49:12
|
| Hi Matt, Check the Cluster Admin Console to see what nodes are part of cluster. It will tell you what node is currently acting as the Active Node and where the services are. You might not have the tools installed on both nodes; but you should have the binaries on both servers. If you can't see the SQL Server Binaries and Services on both servers you might not be looking at the right node. There are many reasons for failover, for DISK I/O to cause failover your entire physical server has to go down. That does not seem like the case, I would check to see if there were any network issues between the two servers.Thanks.-- Mohit K. GuptaB.Sc. CS, Minor JapaneseMCITP: Database AdministratorMCTS: SQL Server 2005http://sqllearnings.blogspot.com/ |
 |
|
|
maramor
Starting Member
18 Posts |
Posted - 2009-03-10 : 13:46:35
|
| OK so it is possible to roll over without the management console. Humm well that makes it really hard to manage. So inorder to get reporting and all that stuff back I would have to roll back? That bassically makes this machine a lump of @#$%. It at least keeps everything up.According to the Network team, no issues. I will have to check back with them on this becasue there has to be something. I don't want to roll back to a broken machine, but I am not getting snapshots and reporting. Jobs are firing as normal as best I can tell. I just don't get the notifications.on a side note, is there a way to be notified of a rollover (before/after).Thanks,Matt |
|
|
|
guptam
Posting Yak Master
161 Posts |
Posted - 2009-03-10 : 16:03:34
|
| Failover notification can be built using notification services. I did have to find you script on how to do it; I don't have it handy. If you google it you should be able to find something.It is failover clustering, so if it didn't failover automatically I did hate it heh. But in clustering reporting services require special configuration to work properly. If you don't have it configured properly it can easily not work, you should be able to access report server admin page using http://SQLServerName/Reports/. If not check you are most likely failing on logon or failing because the service master key is not set.How many nodes in your cluster?-- Mohit K. GuptaB.Sc. CS, Minor JapaneseMCITP: Database AdministratorMCTS: SQL Server 2005http://sqllearnings.blogspot.com/ |
|
|
|
maramor
Starting Member
18 Posts |
Posted - 2009-03-12 : 10:11:12
|
| I will look into that thanks for the info...We have 2 right now. Simply a failover active/passive. I relized with the information you pointed out that since the main server was still alive I can use the Management Studio from that server to configure. Same with the San SnapShot software. Jobs still don't seem to send notifications upon completion, even though I checked configuration? The only thing is if the server does not have the tools installed if the main server was down you are out of luck until you get main server back. I guess I could use tools from any where. I still have a lot to learn... Thanks,Matt |
|
|
|
guptam
Posting Yak Master
161 Posts |
Posted - 2009-03-12 : 10:21:59
|
| You tools can be used from you passive node or active; just have to make sure when you enter server name it is the Virtual Cluster Name and not the physical server name.Thanks.-- Mohit K. GuptaB.Sc. CS, Minor JapaneseMCITP: Database AdministratorMCTS: SQL Server 2005http://sqllearnings.blogspot.com/ |
|
|
|
|
|
|
|
|
SQL 2005 Cluster Rolled Over!