Unable to maintain database

[kraada]

Keep in mind if your hard drive is beginning to fail if the corruption gets worse the issue may recur.

[Assassin85]

This error is actually a bit different than the one earlier in the thread and tends to indicate hardware level problems. Please try running Scandisk on your machine as it's likely your hard drive is having problems.

did'nt like to hear that

I tried the Scandisk as shown @ https://support.microsoft.com/en-us/kb/2641432
First I made the standard scan with only one check @ "automatically fix..." and after no help I made a second scan and longer/deeper scan with a second check @ "scan for....", but didn't help either.
After that I searched for new Windows updates and installed them, run programms like CCleaner for looking/repairing/deleting problems with registry stuff and so on, but still get the same kind of error when I start to "reindex" my DB
I also updated my PT with the updates from recent updates a few days ago.

I have no idea at all what to do next and how to get my own DB (most important!!!) and the second DB with the other players hands (not so important) get working again.

DO YOU HAVE ANY IDEA?!?

[kraada]

Are you able to make a backup successfully?

[Assassin85]

Yes, but with different results!

for my own DB withouth errors: http://i.imgur.com/bkxuXRy.png
for my other DB with errors: http://i.imgur.com/Zt6P9n3.png

after that I tried again a "reindex" for my own DB, because there where no erros and DB looks fine, BUT:
http://i.imgur.com/7rMpmCu.png

my last and only hope/option is to backup everything on my computer and format and reinstall everything new. Windows and all the pokerstuff step by step.
I don't see any other option to solve that.

but maybe YOU?!?

[Assassin85]

have downloaded samsung magician to analyse my SSD (only have one SSD, nothing else), if there is maybe the hardware problem you think is the reason for the error.

http://i.imgur.com/k8rVWNx.png
but everything seems to be fine.

the only "error" is about the SATA 6 connection, but don't have that option (think so)

[kraada]

That's good to hear. It's also possible that this corruption occurred as a result of power loss or something like that. Given the error building a new database is going to be the simplest and easiest way to get your data back, especially if you still have your processed hands.

[Assassin85]

ok, going to format my computer and setup everything new and create a new DB and import my old hands and hope that then the problem is gone.
thx so far

[Assassin85]

I reinstalled my Windows, Pokertracker and with that also the newest SQL version which downloaded and installed the assistent of the PT-installation.

First I made my own DB, importet the hands, importet my safed configs for HUD, notes etc and then made the maintance stuff.
reindex, cluster, vaccum and then the two cache things -> everything worked fast and fine!

BUT then I made the second DB with hands from other players.
Import went good, the reindex, cluster and vaccum was also fine, BUT then the cache things:
I got this when I made the Full-cache: http://i.imgur.com/u2lTuag.png
and that when I made the custom-cache: http://i.imgur.com/p8DV5z6.png

any Idea why I got this messages and how to solve that problem?

[kraada]

How many hands are in this data set (roughly)?

[Assassin85]

I think ~1,7 million hands.

it's a ~11 GB size DB, so not that big in my opionion.
my other (own hands) DB is ~7 GB big.