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 |
|
vdavid70
Yak Posting Veteran
67 Posts |
 Posted - 2005-04-18 : 07:35:59
|
| Hello Guys,What command do i write to know the latest version of my sql 2000 service pack.Secondly i am trying to set up a standy server and configure log shiping in my enviroment. We operate windows 2000 cluster servers and it has been going nutters for the past two weeks therefore i havee descided to change it to logg shipping setup. The question now is that what precautions do i need to take before doing this and what procedures do i need to follow to acheive the new setup both before and after the installation.Cheers |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-18 : 08:25:18
|
| http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185#2http://tonybain.com/blog/posts/206.aspxInstead of switching to log shipping, why don't you fix the issues you're having. What do you mean it "has been going nutters"?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
vdavid70
Yak Posting Veteran
67 Posts |
Posted - 2005-04-18 : 08:46:13
|
| Thanks for the suggestion. I have tried all possible solutions to the cluster but to no avail. The error messages have all been pointing to hardware and network issues. Checked all this but all seem to be fine.This is why i am goin for the option off building another sql server installation then rebuilding the failover cluster. but sying that i still wantto point the new sql server box to look at the data on the SAN the cluster is using, is this a possibility or not.CheersV David |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-18 : 08:50:08
|
| What are the error messages? Maybe we can help you. If you have network and hardware issues, then you need to solve them quickly.You can't have a different server look at the same data on the SAN the cluster is using. You can use a "snap" on the SAN to look at a point-in-time version of the data, depending on what type of SAN, software, etc you have. The actual LUNs on a SAN are not shareable across multiple hosts at the same time. Even if they are, you don't want to do this where SQL Server is involved.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
vdavid70
Yak Posting Veteran
67 Posts |
Posted - 2005-04-18 : 09:45:56
|
| Thanks,I have posted this topic before, but not a lot of people seem to be responding.To explain the set-up a bit , I think we have a 2 node active/passive setup, with the first node and sql server name called crm1 and the second node and sql server instance called crm2, both are configured with a virtual name of CRM. The Crm1 and crm2 both share logical drives F and G and a quorum drive E. The data files are installed on the logical drives while the system files are installed on the individual nodes local drives separately. I hope this explains the situation a bit more.Now initially crm2 was handling all the active resources on the node. When it started having problems it switched over to crm1. Since then I think it has switched from one node to the other up to 10 times and still doing so. While doing this a lot of Cluster resources such as sqlserver services and agent fail and restart it self after a while.Now this morning. All the resources and groups are now back to CRM2, the original primary server. But just before that the nodes have unexpectedly gone on and offline. Coming up with the former errors it had, such as;The windows Event viewer comes up with series of errors saying The node failed to join the cluster error code 1717.Cluster services suffered an unexpected error , fatal error at line 2166 of source module d:/nt/private/cluster/service/dm/dmlogs.The node failed the process of rejoining the cluster. The error code was 5Reservation of cluster disk has been lost please check your disk and system configuration.How do you suggest I tackle this problem? And what are the steps to take to put things right. How do I check if the cluster hardware and services is working well as well as the network connections? At this point will it be wise to take the crm1 node out of the cluster and re apply? And what do I need to make sure is right before doing this? To add to all this i come from a development background into DBA ,therefore have little knowledge of hardware and network issuesand this is the first time i will be facing a cluster problem so please understand where i am coming from.Cheers,V David |
|
|
|
|
|
|
|
|
Service pack