Duplicate Hands

[kardashian]

I find occasionally duplicate hands, I've exported some of them and compared; exported hands were identical in every way (HAND ID, TIME, PLAYERS etc).

How can I cleanup database?

[fozzy71]

That is generally a sign of a corrupted database. There is no easy way to cleanup all duplicates if your database was somehow corrupted/damaged*. The easiest way to try and solve the issue is to create a new database and import the hands again. Please try to create a new small/test database: File - New Database then manually import some hands via File - Import Folder - from C:\HM2Archive and/or C:\HM3Archive.

* This is why regular backups are a good idea. If your database becomes corrupt, or you have hardware problems, you can restore a backup and only have to import the most recent hands (that were played after the backup was created) and edit any tournament results played after the backup was created if necessary. I recommend keeping at least the most recent 2 or 3 backups so if the most recent one does not restore properly for some reason you can try the previous backup. You can make a backup of the active database at any time by using the Tools - 'Backup Database...' menu.