fat888 wrote: How can I remove the transaction log without backing up the database? Well, now that you're in trouble, DUMP TRAN database WITH NO_LOG but that's not a recommended procedure. On a development machine, this can be excusable. Backups are way better. "In an organization, each person rises to the level of his own incompetence." Peter's Principle