You will find some good scripts in this forum that use DBCC SHOWCONTIG to decide if to reindex or not....
When you add the second node, SP4 should be reapplied to that node if I remember correctly. At least thats how the rebuild master tool works, it will...
It has to be in a cluster group that has an IP and a name resource as well. I don't think your backup drive has that unless it is located in your SQL...
If you dont have heavy MSDTC usage let it use the quorum disk instead. The MSDTC service will den be located in the default cluster group where you...
What is the error you get.
What the application need to handle is to reconnect after a failover. The SQL Service is stopped and then started during a failover so the...
I'd recommend www.eventid.net http://www.eventid.net/display.asp?eventid=1069&eventno=797&source=ClusSvc&phase=1
Make sure that: - you login and install with an account that is administrator on both nodes - the remote registry service is started in both nodes.
Change T:test_log.ldf to T: est_log.ldf
quote:Originally posted by KGautney I was able to connect to the instance by editing the host file. This indicate a DNS problem. Verify that both...
Yes but it must be on a shared cluster disk and not a local disk.
All disks used by SQL server must be shared disks in the cluster. On the SAN in your case. Cluster info:...
You need to take the SQL Server resoruce offline to add a new disk as a dependancy and then start it back up. It has the same ramifications as...
quote:Originally posted by eleung Thanks again guys. The reason for the Clustered File Share because the drive is indeed a local drive to the...
There seem to be quite a few issues. See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65046
There see to be quite a few issues. See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65046
There is no need for an extra MDAC install. Windows 2003 SP1 with patches contain the latest MDAC (2.8x) already.
Follow:http://support.microsoft.com/kb/301600 As long as you have correctly configured the default cluster group to have a cluster ip, name and...
It is possible to force the sql server data onto the quorum disk but you will get a warning during install that you should not configure databases on...
If it is not heavy MSDTC usage you can put it in the default cluster group and use its ip, name and quorum disk....
Separate names with a comma.
