Clusters are not really complex things.

In a nutshell, there are Cluster Groups. You install SQL, and its resources get added to one of these groups that you specify. Then, through...

Go to cluster manager, right click the SQL group, and go to Move Group..that should put it back on Node A. Is that what you were asking?

WayneS (9/14/2010)

---

Nope, not a limitation. It's only available for THE NEXT select/insert/update/delete statement. The one that it's failing on is the second statement.

You might want to look at selecting the...

Ah..you're completely right. I looked it up and it looks like it's a 2008 feature. I wasn't aware of that. Sorry about sending you on a wild goose chase.

I guess...

Halcyon (9/14/2010)

---

hi, yes I agree that it is a good way of doing it, but if you have the LUNS arranged over one array of disks, then isn't it defying...

Open up the maintenance plan, open up the task you're running that's failing, and then click the Databases dropdown, and you can select which databases the task runs against. At...

steveb. (9/14/2010)

---

torpkev (9/14/2010)

---

My biggest annoyance with sa - quite outside of this discussion - is those people who use sa to connect to the database because they don't know...

Nope..can't use local...

Are you using a login that has DBO to master?

It sounds like you just can't see the Sys schema..

In the maintenance plan where you select the databases, just check the box that says do not attempt on databases where status is not online.

I agree that it's silly that...

But is it a multi-instance active/passive cluster? Or active/active? Or passive/passive (oh...

Sure

DECLARE @LoginAudit TABLE (

ServerName nvarchar(255) DEFAULT @@servername,

Time smalldatetime,

ProcessInfo nvarchar(50),

Text nvarchar(1000)

)

INSERT INTO @LoginAudit (Time, ProcessInfo, Text)

EXEC sp_readerrorlog 0, 1, 'Login failed'

select top 20 ServerName, Time, Text from @LoginAudit

WHERE Time >...

It sounds like you could use DIFFERENCE()

Doing something like:

select difference('ROBERT','ROBART')

Returns 4, which means they are very similar

Whereas executing:

select difference('ROBERT','ROGER')

Returns 2, which means little similarity

And executing:

select difference('ROBERT','JASON')

Returns 0, which is nothing...

The setup is really no different than active/passive.

Just install two instances, and then move one over to the other node.

If someone is guessing/brute forcing your SA password, you have bigger issues...

I leave it enabled on my servers, but run a job every day that sends me the failed logins...