Well, I do backup my database. I actually wrote an AutoIT program to do it every night while I'm sleeping. The backups are always named by the day of the week (Monday, Tuesday, etc...), so I always have 7 available daily incrementals.
However, I didn't want to restore until I tracked this problem down thinking that others might possibly be having this problem. I tried using the "Edit Studios" function to delete all of the studios in my database. All movies had no studios associated with them and the "Edit Studios" function was completely empty but, alas, this did not solve the problem. I still got the error, even after deleting all studios and repairing the db.
Oh well, db restore worked like a champ though. |