Hi folks,

I just want to point out that although I have been ranting on about the benefits of attach/detach for a database test machine, I have to concede I have missed to many valid points out to be able to validate my arguments anymore. In particular:

When I use FOR ATTACH_REBUILD_LOG I obviously no longer have a logfile. To that end there is no ability to rollback inconsistent or uncommitted transactions on startup, hence an inconsistent state. I was warned of that several times here but didn't think deeply enough.

To that end, there is truly no replacement for a good backup and recovery strategy and my own environment now reflects that.

Many thanks to all for your constructive comments (even if sometimes they were the result of an enormous amount of patience!).

Kev