Database Back up error

Divya · 2009-04-16

Hi,

I need some problem while taking backup of SQL Server Navision Database.

Please see the attached error image.. Please do the needful

Belias · 2009-04-16

are you restoring or backing up?
i hope you're backing up, because in this case you can check your standard text table (code fields) for strange or lowercase characters.
Then, correct them and redo the backup.
if you are restoring, you have to check the original db, correct the values and then redo the backup.

kapamarou · 2009-04-16

Look at table 7 "Standard Text". There is a problem with a value in the code field (maybe larger text from a SQL insert?).

Divya · 2009-04-16

Thanks for all who suggested me solution for this issue.........

This issue has been sorted. I have deleted records in Standard Text Table thr back end (SQL Server). Now i can able to take backup. Might be some data problem in Standard Text Table.

Once again thank u...

mohana_cse06 · 2009-04-16

i think this is not the perfect solution.

Dont delete the data any time.
[-X
you may face problem later.

Belias · 2009-04-16

mohana_cse06 wrote:

i think this is not the perfect solution.

Dont delete the data any time.
[-X
you may face problem later.

true...but deletion of data can be sometimes a miracle 8)
anyway, investigate WHAT is the wrong data, then correct sql store procedures accordingly.
for example, do an uppercase to all code fields

mohana_cse06 · 2009-04-16

Belias wrote:

mohana_cse06 wrote:

i think this is not the perfect solution.

Dont delete the data any time.
[-X
you may face problem later.

true...but deletion of data can be sometimes a miracle 8)
anyway, investigate WHAT is the wrong data, then correct sql store procedures accordingly.
for example, do an uppercase to all code fields

As the datatype of field code is CODE, i think no need to write in uppercase.

but i think the problem is with length. :-k

Belias · 2009-04-16

maybe i didn't explain correctly:
if you insert a lowercase value in SQL (through sql scripts or manually from management studio) in a code field, it will remain as is.
Nav can't read this value and often crashes when trying to read the value.

mohana_cse06 · 2009-04-16

Belias wrote:

maybe i didn't explain correctly:
if you insert a lowercase value in SQL (through sql scripts or manually from management studio) in a code field, it will remain as is.
Nav can't read this value and often crashes when trying to read the value.

Ok :-#

Belias · 2009-04-16

no problem

take it easy

Database Back up error

Answers

Categories