Thank you for that.  I've been looking in the SQL error log where there were no errors, but forgot that there was also a SQL agent error log.  In it,...

Sorry,  I was using the Disk Usage by Top Tables report and it was not totalling to the used size of my database, so i believe it's not calculating the...

ok, i found something about text fields.  that is likely it.

There are no Audits running on the database.  The database is on a clustered server, if that's what you mean.

Thanks!

Thanks so much for your response. I checked the properties of the content manager role and it does have MANAGE DATA SOURCES checked, as well as everything else.

In addition, I...

Thanks, my non-sql scripting skills aren't that great, but i was able to write a powershell script to copy the file from the sharepoint URL to a local folder.

Still curious...

Thanks. Yes, I understand I need to uninstall and install. I was just wondering if there is anything I need to watch out for. Do I need...

more information: I found out that on the server with greater reads, it always generates a CacheInsert event, but on the server with lesser reads, it generates a CacheHit...

Thanks for the help! - I did figure out how to do it with the data-driven subscription. and yes, it was very straight forward - I was thinking too...

Can you tell me how you did it with a data driven subscription? I looked at that, but couldn't see how it could be done?

Thanks!

Yes, it connects to the SQL Cluster name. It works fine most of the time, just for an intermittent span of 1-2 minutes. I don't see any performance...

This is a SQL 2005 Standard x64 instance on a windows 2003 Enterprise x64 Cluster. I'll try changing the connection to use Servername,Port - although, since it's using the...

It's connecting using the Servername, which resolves to the IP address (presumably, during this time). It is the default instance using the standard SQL port.

Thanks,

STeven

Yes, there is a witness. Thank you for this list. I will run through it and see what I find. It usually occurs in the middle of the...

Not backups, I checked that one, but Antivirus, maybe. I'll have to check that one.

Thanks for all your suggestions.