It is normally my first "big splash" when I start a new contract, to insist the dev environment is refreshed at some regular interval (hopefully nightly!). The pain to re-apply...

Andy,

Although I agree with you overal position, I absolutely disagree with the line "but a damn good starting point is to just add a identity column called rowid and make...

When a tlog backup is done, all the committed transactions are written to the TRN file. Depending on your backup statement, these committed transactions are truncated from the log. However the...

from BOL: "Under special circumstances, contains rows corresponding to the files in a database."

anyone know what these *special* circumstances may be?

Dan

Attaching an MDF without an LDF inplace will create a new log file, the db may recover to a point, maybe, maybe not - worth a go.

unlucky thou

Dan