Thursday, April 10, 2008

10-10-06

Fixing Thunder Database Problem

Unique key error means SQL DB for that Thunder file has become corrupted. To fix the problem the SQL DB must be deleted and then recreated.

1. On Thunder-SQL run the SQL Query Analyzer (Program files/MS Sequel) Password is “xxxx”

2. Go to FILE/OPEN and select

MAKEALL61.SQL (which is located on the desktop)

That should delete the DB.

3. Return to Thunder server. Open problem DB. Window should be empty.

4. Select FILE/ADVANCED/REBUILD DB (do not change any selections)

DB will be rebuilt in about 15 mins.

LANCE at OAGSUPPORT for Avid is the best person for this.

No comments: