I would recommend using Storage Gateways for SQL Server backups to S3 in an enterprise situation.

While you can attach an EBS volume and sync to S3, the cost for...

The article presupposes that the source server is an AWS EC2 machine. If that's the case, why put access keys (the equivalent of a username/password) in plaintext into a configuration...

Dumb question, but have you engaged either or both of Netapp or Microsoft?

Are you using Snap Manager for SQL? If so, I'd suggest trying to do a native backup to see if it's NetApp that's misinformed regarding the state of that block...

Would culling the information from sys.dm_exec_connections/dm_exec_sessions be acceptable?

The first step that I'd take would be to make sure that the articles are indeed gone. Check the sysarticles table on the publisher. Next, I'd use profiler...

Mick Opalak (8/16/2011)

---

I'm assuming that the source of the problem is becuase the Publisher is SQL2K5 and the Distributor and Subscriber are SQL2K8. To get around the problem we're...

What is the @pre_creation_cmd for this article? Is it "drop"? If not, can it be changed to that? Do you have option to initialize from a backup?

KeePass (http://keepass.info) will archive old passwords for you. It also handles expiration, so you can look at your archived and know which dates it was active. Plus...

What is the value for pre_creation_cmd in sysarticles for the article in question? If it's 0, then replication isn't configured to get rid of the data before running the...

So, I issued a catalog rebuild on Wednesday before I left the office. According to the query that you gave below, the crawl never completed. Are there any...

456789psw (11/24/2010)

---

if you see the Item count...at 0 wait a while....depending on how big the Full text index is it could take a while...

also what does your last population date...

Perhaps I'm missing something, but couldn't this be solved with some math? That is, if I have a rate to be applied a certain number of times, then I...

Yeah, I'm on Enterprise Edition SP1 vanilla. When I get a spare minute, I'll start looking through the CUs and see if any of them addressed spatial index usage....

I ran your script and looked at the execution plan; it's using a clustered index scan on the table. I'm running on SQL2008 SP1 if that makes a difference.

StmtText

-----------------------------------------------------------------------------------------------------------------------------------

...