Egads - on a production system? 🙂 No, you're right. Should've added a harmless sproc or something.

Thanks. In theory, it sounded like it would work.

@Gila - I had thought of that and completely forgot to ask - will log-shipping transfer database objects as well or is it only data records after the initialization?

@ninja's - thanks again for another good suggestion. Just spoke with the business owners and they would rather have sluggish reports than miss data for a brief...

When you check the Security folder under that database, is there a "Public" user there? If so, what roles are configured? That is not a SS default.

We don't care about keeping the data - it's just session state stuff. And there are only a couple constraints, but I've already mapped them out on the new...

So even with tuning down the deletes to just 2500 per run, we've run into some lengthy table locks which have already resulted in our website being inaccessible. I've...

You know, I figured it probably had to do with duplicates being in the same batch. Anyhow, that's a terrific idea, thanks!

Thanks, everyone.

bah! I was trying to get around that. Sounds like I'm probably hosed. Thanks, though.