Problem In Restoring Db

avs_MBS

Dear All Nav Experts,

This Is Avs, i am getting problem in restoring DB Backup. The Problem Come with the Following Error messag.
Error- "Error In overflow decimal".
When I test a database after selecting option for checking primary key and data,secondary key the error is same as that comes in restoring db.Please let me know youall how to sort out this problem..

ara3n

Start testing the tables one at a time till you find the the table that has the corrupted data.

file->database->information->tables->select tables and click on test.



Once you found the table. Export the data with a dataport, delete all the record from the table.
Import the data back with a dataport.

Good luck.

kine

Just a tip: on MS SQL you can change decimal precision by runtime parameters of the server. If you have some backup from server with changed precision and now you are restoring it to server without that change, you can have some problem. If it is this case I do not know...