Problem restarting db

D

dmccloskey

New Member
eB2 / 9.1D

New to the admin side of QAD. We have a program called ProControl that will allow me to stop a database that I want to copy the production db to. There is a .bat file that will actually do the copying. Problem is that when I go to restart the database, it times out. When I try to copy to the database again, it says that the db is still up.

Help please...
 
I never trusted ProControl & Explorer tool, I always use stop/start batch files. Errors are evident on the screen. Any way see the .lg file of the database and decipher the issue.
 
Thanks for the suggestion. I looked at the .lg file for the db that I cannot get started. It says:

Wed Sep 01 19:32:04 2010
19:32:04 BROKER 0: A previous prorest s:\sql-db\sqldb failed. (614)
19:32:04 BROKER 0: Multi-user session begin. (333)
19:32:04 BROKER 0: SYSTEM ERROR: The before-image file has the wrong cluster size. (881)
19:32:04 BROKER 0: SYSTEM ERROR: The broker is exiting unexpectedly, beginning Abnormal Shutdown. (5292)
19:32:04 BROKER 0: drexit: Initiating Abnormal Shutdown

The same thing is posting every time I try this. Suggestions on how to fix this problem? I did learn that I needed to run ProControl from the console and not through Terminal Server. Wasn't told that before I did it.

Thanks.
 
The error message states clearly that a previous restore failed. Obviously somebody tried to restore the database but the restore failed for reasons we can't see from the snippet of the database log file.

Right now your database is in a corrupted state - rendered unusable by a failed restore. In order to get it up and running again you must successfully restore it in the first place. There is no other option available to you.

Do you have a copy of the database before the attempted restore failed? This might be your last resort ...

Heavy Regards, RealHeavyDude.
 
Thanks for the info. The good of it is that we don't actually use that database anymore as it was only required when we had sales reps. A former employee had created an Access dB to create commission reports. However, I'd still like to get it up and running again. I believe it was a copy of our production database. Sounds like I'm going to have to get someone in that knows what they're doing and watch intently on restoring a database.


Found this in the .lg file:
Sun Jul 12 13:05:26 2009
13:05:26 prorest session begin for Administrator on batch. (451)
13:05:53 SYSTEM ERROR: Attempted to exceed maximum size on file s:\sql-db\sqldb_35.d2. (9452)
13:05:53 Restore failed. (1618)
13:05:53 !!! ERROR - Database restore utility FAILED !!! (8564)
13:06:17 prorest session end. (334)
 
You must log in or register to reply here.
Back
Top