Question

I want to remove all cases from my FogBugz system safely. How do I do it?

Answer 1

Back up your data!

We've seen unpredictable results with just emptying the tables, so we recommend leaving case 1, the sample case, in the database.

Is your data backed up?

• DELETE FROM Attachment WHERE ixBugEvent > 0;
• DELETE FROM BugEvent;
• DELETE FROM BugView;
• DELETE FROM BugRelation;
• DELETE FROM Duplicates;
• DELETE FROM Scout;
• DELETE FROM TagAssociation WHERE ixBug > 0;
• DELETE FROM Bug;