Thanks for the article! I used to be a fan of the detach/attach method of moving database files around... that is, until I brought down Service Broker for Operations...

John,

Thanks for replying. I targeted three server in total, and only one of the three had Windows only authentication. The other two had SQL and Windows authentication.

I try...

It's me again...

Okay, once I get the database to the secondary site, I can restore the database to STANDBY pretty easily. So forget that part, and let's focus on...