Hi there

From memory here, I didnt "title" the article so the SSC crew gave it one 🙂

Fair comment though, I have a few client sites that required 24x7, and attaching and de-attaching is not suitable. To get around this we could:

a) replicate (can be complicated and you need to be 100% sure the schema is identical

b) log ship (very fast)

c) script schema, read-only prod, and populate new server via linked server routines (no keys)

the swap as need be at the business layer.

Cheers

Chris