Database won't start: dbname.bi and dbname.db Mismatch

[HFP]

Hi all, I once again need to call upon your expertise I am afraid!

At the weekend (end of month) we take a Procopy of our database for reporting purposes. It is Progress 9.1D.

The procopy ran over midnight (it wouldn't normally) taking it to the next day. Once it completed it failed to start, reporting the following errors:

Message from PROGRESS database U:\monthly\dbname (5199)
SERVER : ** The database was last used Sat Mar 01 21:28:49 2008. (886)

I have found out that whilst the procopy was happening the source database was started up by another task. Despite this the Windows Event viewer shows the procopy as having completed successfully.

Having used the knowledge base it suggests truncating the BI files however on trying this the following message is received:

PROGRESS Version 9.1D08 as of Tue Jan 20 17:34:57 EST 2004
** The database was last used Sat Mar 01 21:28:49 2008. (886)
** The before-image file expected Sun Mar 02 00:00:21 2008. (887)
** Those dates do not match, so you have the wrong copy of one of them. (888)

Can anyone suggest a course of action? I have backups however they now incorporate additional days information which would skew the reports. It would be infinitely preferable to get this DB back up and running!

All help/questions gratefully received!

 

[Casper]

The database has to be shut down for procopy to work correctly. So you have to do it again, maybe next time make you better maken an online bakcup of the database and restore it to get a copy of the production database. Be glad you didn't do this the other way around (copy test to production :awink.

Casper.

 

[HFP]

Hi Casper and thank you for your reply.

I suspected as much, it's a schoolboy error unfortuantely - I wasn't aware of the other systems connecting in. Too many cooks etc..!

Cheers
HFP