Correct.

No. My issue has been I've been thinking (and my group too) from a O/S level, and not instance level. It makes a lot more sense when I...

Ok. Thank you very much for the clarification. My confusion was on the nodes and instances then.

I know that Clustering is not a load balancing solution. Unforunately, mgmt doesn't see it that way and I think I've convinced them it's not.

I will describe our set...

We have two processes right now;

A MPlan Transaction log backup that runs every 6 hours (we are more of a DW env, not OLTP). These backups are stored on...

Ok, so if the log is truncated every time....

My log shipping runs every 15 minutes.

So at 5:47pm I ship off my logs to the secondary server.

At 6pm I back up...

Great catch there, I completely forgot about that.

Well, part of the discussion going on is do we want sa, as it is a well known account on SQL? Obviously creating a very strong, ever changing password...

Do you guys have a good query to use to check for the % of frag, and # of pages?

I'm assuming you're checking the dmv for index_stats correct?

I should state this is actually what I run:

SELECT * FROM sys.dm_db_index_physical_stats(db_id, NULL, NULL,NULL,'LIMITED')

Works fine on test, and that's with 54 million records and SP2 installed.