Micros 3700 Backup Database

[sky1980]

What is the process to restore a daily database backup (xx.db.good & xx.log) to a working database (.DB & .log)?

I have tried to rename by changing the extensions, but then the nightly validate process records errors.

Micros 3700, rev. 3.2.xxx

 

[hosehead78]

Sorry, not sure here. Hopefully pmegan will read this and give advice.

 

[mrunowho]

You need to restore the database along with the keys through the Database Management utility. Backups should be in .mbz5g2 or .mbz5 format. I would make sure you validate it first through the utility before trying to restore it.

 

[pmegan]

Res 3.2 is ancient, it was pre-PCI and doesn't have database manager, encryption keys or .mbz files.

Restoring the database is just copying in the backup db and log files, as you did. If it's failing validation rebuild it. You'll find the rebuild in the database section of Start / Programs / Micros Applications. There's also a way to force the database to start without a log file. If the rebuild fails you may have to go that route, but you'll have to do a little digging. I think the program that you use is dbserve, it's in the same folder as dbisql.exe. There's a -F switch that will force the db to create a new log file. I don't have the specifics at this point. I upgraded all of my 3.2 systems in 2006 and haven't worked on that version at all in over 5 years.