Subject Re: [firebird-support] Generators, what could cause resetting generator values to some earlier version
Author Mark Rotteveel
On Wed, 08 Aug 2012 09:40:13 +0200, Sofija Blazevski
<sofija.blazevski@...> wrote:
> We tried getting database backup over our local environment, backup and
> restore went fine, generators kept their "old" values - that's what I
> expected though.
> It does seem like old database, I would believe it was replaced if the
> data were not up to date.
> I can suggest system restore to the client, but it would need to be
> really justified, as that server serves as more than database and our
> application server. I'm trying to get exact specification of its usage.

I think Bogdan meant that some System Restore options are known to
overwrite files with older versions of that file. Eg on Windows 7
Enterprise and Ultimate you have the option 'Restore previous versions' and
if Windows Backup is enabled it is easy to revert to an older version of a
file.

You might also want to check the location of the database file. If it is
on Windows Vista or Windows 7 with UAC and the location is in the Program
Files folder it could also mean that the actual database is in the virtual
store folder in the user profile.

Mark