Well like they say, the trick is whether your backups will restore. I think we only have two Idata Agent licenses so we might need to use the...

Thanks, I'd forgotten about the copy_only backups. Based on what I've found in the way of Commvault forums dealing with sql server, it doesn't appear to be widely...

Just found this thread. My understanding ( for Commvault ) is that the backups are not native sql backups and you can't be doing native sql backups if you...

We have some tables with millions of records in them. What we seem to be finding is that, in general, sampled updates of statistics creates problems. ...

"If that was for me, I'm well aware what the rules for statistics updates are."

No just posting the documentation for my benefit and whoever else may read this.

thanks again.

Thanks Gail. So you're recommending targeted updating for problematic indexes weekly. And I suppose more often as needed. Auto updates on.

It looks like sp_updatestats only has one...

The environment in question is our new product and I'm still primarily supporting our legacy environment. So, it's the database architect in the new environment who watches things daily and...

The problem with that is if the nightly resets the row counter, then the weekly full scan won't touch everything desired in the time we allow it. Running a...

A little further research shows that sp_updatestats does bump the row counter ( rows modified ) which would cause the weekend fullscan job to select fewer indexes for a...

As far as the stsadm tool, I'm guessing it's only accessible from the Sharepoint web server which I don't have access to, yet. As far as using...

Thanks Eddie.

Yes. I've heard IFI is of no value with SANs ( Netapp in particular ), so I'm looking to see if there is documented evidence to the contrary.

I can't say that I completely understand thin provisioning, but if the storage device presents disk space "on demand", and then the server OS and sql 2005 insist on writing...

I think the main concern now is that Microsoft and others have stated the possibility of data corruption if sql starts up before a mount point is "available." ...

Access to cluster administrator is a secondary issue. We had a meeting on this today and we may try to use 8 drive letters instead of mount points. ...