Database

[Gesi7]

Size of my database is veryhuge. I have played today 600hands, and my DB increase for 4gb. Few day's ago DB was 38GB, now 85GB. What happen, how to decrease size? I v done full vacuum, but size of DB staying 86GB. I am using SSD, afraid what tommorow when i will 3k hands per day , it will storage about 20gb . Help please.

[DogNamedBluff]

Please try creating a new database and reimporting the hands from the C:\HM2Archive to resolve this issue as your database may be corrupted.

All original hands that are auto-imported get moved to an archive for performance reasons. Your \HM2Archive is in C:\HM2Archive by default, but you may have put it anywhere. The archive should be organized by \Month\DayOfMonth (example: D:\HM2Archive\2009\07\31).

[Gesi7]

And how can i delete old database?

[Gesi7]

How can i backup NoteCaddy notes, and restore them at new Database? Or it's impossible?

[DogNamedBluff]

And how can i delete old database?

1 - HM2 Database Manager > Click the '-' symbol to delete the database.
or
2- Delete the database from this folder:
Windows 7: C:\Users\username\AppData\Roaming\HoldemManager\Da tabase
You must show both hidden files and check unhide system files. See this:
How to show hidden files in Windows 7

Windows XP: C:\Documents and Settings\User_name\Application Data\HoldemManager\Database
For showing hidden files and unhide system files, see this:
Microsoft Corporation

After you have done this you can delete the database from your computer completely by running pgAdminIII and deleting the database.

How can i backup NoteCaddy notes, and restore them at new Database? Or it's impossible?

The notes will need to be written again.