Subject | Re: Cannot restore 32GB DB - fails at end, unusable. Any ideas please. |
---|---|
Author | |
Post date | 2016-04-12T21:04:14Z |
I'm now trying to restore it with "ignore validity constraints" off in flamerobin.
It's a production database but this restore is for a side-project (email logging). I clearly need to get to the root of the problem.
The offending index is added to using a generated integer within a trigger so it is very odd to get this error. The system has been up for 6-7 years now, 20-25 users.