cancel
Showing results for 
Search instead for 
Did you mean: 

Restore Database

pankaj_mathur3
Explorer
0 Kudos
60

Hi All,

Can someone please help me urgently.

Our customer is currently running SAP Business One 2005A SP01 PL19.

He would like to migrate to a different server machine.

Following steps are being followed by us to migrate him to a new server machine:

1. Backup the database from the current server machine

2. Create a new company on the new server machine with the same company name and DB name as it existed on the old server.

3. Restore the Database (from enterprise manager) from the old server machine on the new Company DB (on the new server machine).

Even though the restore is successful, however when we update any screen in SAP Business One, the status bar display a message "operation successfull", however when we re-open the screen we notice that the changes are not saved.

It seems that the database is locked or it is in read-only mode which is not allowing any updates.

CAN SOME PLEASE HELP URGENTLY.

Regards,

Pankaj Mathur

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Pankaj you need to restore the sbo-common database also and make sure that you have at least PL19, and in that respect you should upgrade to PL22 since PL19 and PL20 have bug with DI API that where corrected in PL22.

Answers (2)

Answers (2)

former_member201110
Active Contributor
0 Kudos

Hi Pankaj,

The only time I've heard this kind of issue is when there had been a modification to the sp_TransactionNotification stored procedure in the company database. If this is causing an error then SBO might report a successful update but no data is written to the database (ie the transaction is rolled back). Check the stored procedure and see if any additional code has been added to it.

Kind Regards,

Owen

Former Member
0 Kudos

Hi Pankaj,

Did you take the backup of SBO_Commons Database and resore it as well.

Riz