Present Day:

1 Tb db, 1/4 Tb db, 1/3 Tb db on an activer/passive cluster.

failover of all resources from one node to the other via cluster administrator 1-2 minutes.

when active node...

Present day:

system database backups are performed with the maintenance plan 'verify' on. We do not regularly restore the system databases because in our environment it is just as quick to...

we have quite a few clusters, both active/passive and 4 node n+1 clsuyters.

the quorum drive size is 10 Gb on most.

... also ... it is an industry that is not easily outsourced overseas as wel !!!

does the process affect objects with triggers on them ?

Take a look at the 'default' trace for SQl 2005 - it should give you a pretty good start.

Well ... you can actually change things in maintenance plans if you know exactly what strings you need to replace ... I've attached a script that I used for some...

I was one taught that there are only 3 occupations that are fairly resiliant and are somewhat ignorant of the overall economic climate. They are:

- Food --> people gotta eat

-...

SHOOT 'EM !

and yet another "but why" ...

create table ([int] int)

go

insert select 1

go

select [int] from

go

Not to throw a wet towel on things but if that is the case why do SOX and HIPPA exist ?

They do, at least in part, to govern the tasks...

It workd on SQL 2000 ...

My version -

...

Hit the wrong button ...

Let me clarify - Step 3 is needed. However the second part about changing the passive nodes is not needed since cluster services should replicate the...

Step 3 is not needed since Cluster Services replicates the change to the other nodes.

I will not belabor the points mentioned. For taking leadership on ethics my responses are:

- Microsoft - NO, NO, a thousand times NO !!! (nor Oracle, nor Sybase or any...