RES 4.0 Restore to a Backup

[michelle305]

If force start a database is unsuccessful, what are the steps to restore to a prior database? Also, how do you 'drop' a database to troubleshoot and why would you? Thanks in advance. Replies on here are always helpful and I can't find info anywhere else.

 

[DrZogg]

What version of Micros? Is the previous database a CDB, MBZ or just micros.db? And is the log for the restored DB there too or do you need to create a new log?

Steve

 

[DrZogg]

Turning brain on, I Res4 ... must be *.mbz. Do you know how to use DM (database manager)?
Start>Run>DM and select Restore Database.

 

[michelle305]

RES 4.0 But you can't open DM if database is not started, right? so how from the run line? I guess you would have to recreate the .log.
What is the difference between a .db .mbz and .cdb? Version? I guess I mean .mbz.

 

[DrZogg]

OK.
For RES 4 you do the following:
1. Select Start | Run | type scview and OK
2. Double-click Utilities
3. Double-click Un?Compress Database
4. Select Browse and navigate to the directory where the compressed
Micros database is located
5. Select micros.cdb and select Open
6. Select Next
7. At the prompt “What path and filename do you want to use for the
uncompressed database?” either leave as the default (as above), type
in the pathing and filename or select Browse
8. Select Next
9. Select Finish

To load in the DB stop the Micros DBUPdate & DB Services, as well as sqlServerName service. (you should find the last one is off anyway) to unlock the DB and log file.

Rename the DB and log to .old (micros.db.old, micros.log.old)

Copy your new DB into the DB directory. To create a new log file, put the following into a Batch file:

@echo off
cls
d:
cd d:\micros\database\data
echo Press any key to delete the current micros
echo log file (if any) and create a new log file
PAUSE>NUL
IF NOT EXIST micros.log goto SKIP
attrib -r micros.log
del micros.log
:SKIP
echo.
dblog -t micros.log micros.db
echo.
PAUSE
echo.
REM Forces the database to start without the transaction log
dbeng9 micros.db -f
PAUSE
echo.
echo Please close SQL icon in the taskbar once completed
dbeng9 micros.db


Once you stop the DBENG9 (sybase in bottom RH corner) you will have an empty 192k log file.

Restart the services & all done.

Quick question, how did this happen? Have you checked the server name and the name in Configurator? If they are different, then no-start.
Steve

 

[DrZogg]

Hi,
not having agood day at all! That is Res3.
Please try DM

 

[DrZogg]

ok then,
DM doesnt work without a DB running... The most time effective would be to take off all the info needed to restore (\etc, \bitmaps, \journals , all MBZ files, \scripts) and do a clean install without loading in a DB and adding all the patches without a DB in the system.
Then use DM to uncompress a working MBZ and restoring that DB.
You could be up again in 2/3 hours with this option but have to know how to do a clean install.

A micros installer would take an MBZ and restore it on a VM and then stop services, copy the DB & log to USB and load them onto the server, how big is the DB? and is this an option?

 

[michelle305]

Wow, lot of info. DB is just under 1mill kb I think. I was thinking using run line to copy a backup somehow then force start the backup. Not from DM of course. But I dont know the details.