There's not going to be much you can do, you cannot prevent people from doing stupid things when they have total access to the database.

Can you put the database under souce control (SourceSafe) and force your user to check it/out in order to make changes? If you can, you could at least fall back to a pre-disaster state