Thanks for the suggestions on SSIS. Since I have only done very basic SSIS stuff, could please elaborate a bit more or maybe suggest a few links? Does SSIS have...

Nevermind, figured it out.

It was because of the NTEXT field. LOB columns don't get moved so easily. I have to go the "create table/rename table" route.

kevaburg, thanks for your suggestion. I don't see however how I could add particular databases to a server group in CMS. It's correct that I need to manage CDC for...

Hi,

thanks for the replies. As for log use and growth, I'd be fine with it. I can assign enough space and dedicated luns for them. The comment about having 1000...

Thanks for your reply.

Yes I'm aware it should perform better, but I'm still somewhat concerned of having to have 1000+ agent jobs on the SQL Instance. Any way of...

Nice to see a discussion getting started, and I really appreciate all your ideas.

Just talked to management, and before we start looking at geo-clusters, mirroring at disk level (really like...

From what I gather and researched, I would agree that log shipping would probably be the way to go.

Currently the backup strategy is just "Daily Full", but implementing custom log...

Hi, thanks for the quick response.

Of course, I see what you're saying.

Yes, mirroring/log shipping is all an option and under consideration.

That still asks the question how would it work if...

@perry Whittle

The NIC is Broadcom NetExtreme, and yes the latest drivers have been installed.

@mike-2 P Barron

We do have separate FC switches, but I'm not sure I...

Latest info:

Since we also almost completely suspected the NIC as 'faulty', we had to change the motherboard completely on the 'problematic' Node, because the NIC was integrated with it.

Unfortunately, after...

My thoughts were that if it's a matter of the connection to the SAN (fibre cable and/or 'bad' HBA) we would have the problems all the time, and not just...

I've also seen strange behavior in NIC teaming before, and that's why we took that off of the equation too. So, yes we HAD NIC teaming initially, but we removed...

Thanks for your interest.

Port configs are all set at 1 gig,

and the storage is SAN (EMC Clariion CX700).

During manual failover all resources are online pretty much instantly,...

Thanks a lot for the thorough answer.

I have thought of all those approaches but I always kind of stumble when faced with the number of DBs and hardware and investment...

hmm 🙂

guess I would just have to add some 'control' tables and procedures to have some sort of tracking the whole process.