Moving database from one server to another

Yahoo Archive
1
I dont think they are SQL ... if he is having progress issues with word-break and such


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Fri, Apr 29, 2016 at 9:06 AM, amathis@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Is there any reason you just don&#39;t use SSMS to do the backup and restore of the SQL DB?</p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

2

I have installed my 8.03 on a new 2008 32-bit server and everything looks and run okay.  Now when I make a backup of my original mfgsys database and use prorest to restore to the new server and try to start the database I get this error message:

Any Ideas?


Thanks,

Jody

3
Images don't come through in the forum, can you send a link on IMGUR?


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Thu, Apr 28, 2016 at 5:15 PM, jmannetter@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><p><span></span></p><p>I have installed my 8.03 on a new 2008 32-bit server and everything looks and run okay.  Now when I make a backup of my original mfgsys database and use prorest to restore to the new server and try to start the database I get this error message:</p><p><span style="font-size:10pt;"><img width="416" height="295"></span></p><p><span style="font-size:10pt;">Any Ideas?</span></p><p><span style="font-size:10pt;"><br></span></p><p><span style="font-size:10pt;">Thanks,</span></p><p><span style="font-size:10pt;">Jody</span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

4

The error message was:  Error in startup of database localhost:20931:MfgSys803. Message:

BROKER  ** This process terminated with exit code 1. (8619)

BROKER : Multi-user session end. (334)

BROKER 0: Unable to open word-break table file 2. (2736)

BROKER 0: At end of Physical redo, transaction table is 256. (13547)

BROKER 0: Physical Redo Phase Completed at blk 3683 off 1375 upd 0. (7161)

BROKER 0: Begin Physical Redo Phase at 3584. (5326)

BROKER 0: Multi-user session begin. (333) (JUNMsg024)


Thanks,

Jody


5
ah looks like you left your word break file behind try this.Â


WARNING BACKUP YOUR DB BEFORE YOU TRY ANYTHING ELSE BELOW THIS. I AM NOT RESPONSIBLE FOR YOUR BLOWING UP YOUR DB!!!! SERIOUSLY BACK IT UP I AM NOT EVEN KIDDING A LITTLE BIT IF YOU BREAK IT ITS YOUR FAULT... (there that should be enough to get you to back it up... I hope)


This should fix your word-break as well as re-gen your indexes
this is for unicode DB's if you are NOT Unicode remove the cpinternal switch below and it "should" still work

proutil <database> -C word-rules 0
proutil <database> -C idxbuild all

This will reset your word rules

THEN....

proutil mfgsys -C word-rules 254 <press enter>


With the appservers and database stopped from the Explorer Tool:
1. Open the Proenv command window.  Go to [Start] > All Programs > OpenEdge > Proenv  .
2. At the Proenv prompt, type the word:Â
promptÂ
and press enter.
3. Change directory into the folder with the db.
4. In the Proenv Command window, type the following command to change the word-break rules
Type: proutil mfgsys -C word-rules 254 <press enter>
Answer " Y " for yes.
5. Go to [Start] > All Programs > OpenEdge > Data Administration.
        a. Database > Connect.
        b. Click browse and select the mfgsys.db file in your db folder > click Open
        c. Click OK.
        d. Admin > Load Data and Definitions > Data Definitions (.df).
        e. Click on Files and navigate to oe102a\prolang\utf; highlight _tran.df, click Open then click OK twice.
        f. Database > Disconnect; Are you sure? Click yes.
6. From your ProEnv prompt, type the following command to rebuild the indexes.
proutil mfgsys -C idxbuild -cpinternal UTF-8 -TM 32 -TB 24 -B 60000
5. After the index rebuild completes, restart the database and appservers then log into database and retest issue.







Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Fri, Apr 29, 2016 at 10:45 AM, jmannetter@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><p>The error message was:Â  Error in startup of database localhost:20931:MfgSys803. Message:</p><p>BROKERÂ  ** This process terminated with exit code 1. (8619)</p><p>BROKER : Multi-user session end. (334)</p><p>BROKER 0: Unable to open word-break table file 2. (2736)</p><p>BROKER 0: At end of Physical redo, transaction table is 256. (13547)</p><p>BROKER 0: Physical Redo Phase Completed at blk 3683 off 1375 upd 0. (7161)</p><p>BROKER 0: Begin Physical Redo Phase at 3584. (5326)</p><p>BROKER 0: Multi-user session begin. (333) (JUNMsg024)</p><p><br></p><p>Thanks,</p><p>Jody</p><p><br></p><p></p>

</div><span class="ygrps-yiv-2134722397">
 


<div style="color:#fff;min-height:0;"></div>


6
Is there any reason you just don't use SSMS to do the backup and restore of the SQL DB?