Thank you, that did help. If I'm understanding this correctly, restoring to a different server won't cause conflicts with its existing keys, as long as the cert name is unique.

I...

I thought I had verified that everything worked through the Powershell console, but just to be sure, I logged on interactively as the proxy user and stepped through the whole...

I'm on 2008 R2 SP1, but no CUs.

I've found that if I remove a particular table from the query (a simple inner join on id=id and active=1; this one doesn't...

That's what's weird--I never got to building the spatial index. The only index on the new table is the primary key on the addressID.

The only change was going from building...

Thanks Gail, that makes sense--my googling was leading me to the snapshot process, but I couldn't quite find the connection to this specific message.

I'm not actually getting a message about...