Hi Guys, Does anyone know or suggest best way to image SQL 2000 cluster using Acronis' "Trueimage" ver 9.x software? Thanks,
Hi! Just came across an article that describes "how to install patches," thought might be useful for reference purpose...
Thanks for you response and it helps. The max sql memory was a nice tip. But I have a question. Based on above procedure, there will be a time when...
Hi! I have SQL active/passive cluster with 2 GB RAM. I want to add 2GB more memory in each node. What is the best practice to add memory in a live...
Hi! Here are my 2 cents for MSCS and NLB If you are planning to use MSCS for high availability and NLB for load balancing together then I don't...
In addition, when one fails cluster over, instead of using Windows GUI stuff, one can use command line option. The command "cluster resource" will...
Do u have any monitoring tools installed on the server other than Perfmon? For example, BMC or Tivoli?
Have you applied Win2k SP4?
It is only good for test purpose but will not provide you any redundancy if that node fails as quorum is local and not on shared disk.
Regarding 2: Are u saying monitoring "cluster heartbeat?" If you have thrid party tools to monitor Network cards, then one can use those tools to...
One can also add a DNS record for the SQL virtual server name on the DNS server in the new domain.
There are couple of things one may try: FYI:---> Cluster Group not having Preferred ownesr (PO) is not a problem. I have two SQL clusters and...
This was an interesting problem as there was nothing in the logs (Event-->System, scurity, application, cluster logs, etc.). The memory dump was...
Folks, We have SQL 2000 cluster running on Win2k Advanaced with OS service pack 3 and SQL SP2. The cluster has been running smoothly for more than 6...
In addition, if you put these cluster nodes in a windows 2000 domain, it will also help you to setup SQL service accounts authentication or you may...
Thanks all for additional input and will try them.Here is the article that I promised to post:...
Thanks for the input. I am sorry the OS service pack was SP3 on the server. But it is the case here, as we are running low on kernel memory....
I have a SQL server with 8GB on Win2k Advanced SP2 and SQL2000 with SQL SP2. At present system is configured with /3GB and /PAE. With this /3GB, the...
Thanks everyone for the input. It was conflict of Monitoring software provided DLL for disk with Disk Controller Driver DLLs. Once the Disk...
Separate names with a comma.