Just finished the conversation with network engineer, he just changed the ip address of the cluster group to a different one saying the previous ip address was conflicting with some...

Perry,

I found this article but I am not sure what exactly he is referring to...

http://social.technet.microsoft.com/Forums/en-US/winserverClustering/thread/2e7298ec-5443-47f3-8001-2bac1ac78a15/

Event ID :1205

The Cluster service failed to bring clustered service or application 'Cluster Group' completely online or offline. One or more resources may be in a failed state. This may...

We fixed the issue by updating the NIC drive.

Try third party tools........like sentry or nagios alerts.

try sp_replrestart at publisher on the publication database.

while restoring the database cannot be accessed in log shipping. Peer to Peer replication just works perfectly over here.

any errors? Did you try to kick start them manually?

Probably used this query--

select

a.FILEID,

[FILE_SIZE_MB] =

convert(decimal(12,2),round(a.size/128.000,2)),

[SPACE_USED_MB] =

convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)),

[FREE_SPACE_MB] =

convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) ,

NAME = left(a.NAME,15),

FILENAME = left(a.FILENAME,30)

from

dbo.sysfiles a

How you are trying to remove the node?

Thanks a lot!!!!

we have third party tools which monitor these long running queries. Try to download the trial version.

I am working on a new cluster from scratch.

Stupeo (6/28/2012)

---

What storage are you planning to use under your cluster?

In theory, the setup should be the same as far as the Windows cluster goes.

Some good info here:

GilaMonster (6/18/2012)

---

In that case, please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

By repeatedly shrinking, you're addressing symptoms, not...