How can I detect the problem when backup database problem occur?

[unknown]

[unknown]

Hi all,
I faced problem that sometimes when I backup database
by dump database
It appears to be hung.
and the dump file was not succeed.
But sometime it succeeds when dumping database
How should I know that what's the problem that I faced?
May be some trace flag will help me know somethings?
Now I used -T6 in the backupserver starter process.
but it appears nothing that I need because it traced the
open server information.

Thank you for your information in advance.

[Emmanuel Torre]

Post by unknown
Hi all,
I faced problem that sometimes when I backup database
by dump database
It appears to be hung.
and the dump file was not succeed.
But sometime it succeeds when dumping database
How should I know that what's the problem that I faced?
May be some trace flag will help me know somethings?
Now I used -T6 in the backupserver starter process.
but it appears nothing that I need because it traced the
open server information.
Thank you for your information in advance.

what is the log content of you isql command ? Do you use the -t option
in the isql command ? I experienced a bad trip with this option, backup
succeeding randomly because of timeouts ...

[unknown]

Post by Emmanuel Torre

Post by unknown
Hi all,
I faced problem that sometimes when I backup database
by dump database
It appears to be hung.
and the dump file was not succeed.
But sometime it succeeds when dumping database
How should I know that what's the problem that I faced?
May be some trace flag will help me know somethings?
Now I used -T6 in the backupserver starter process.
but it appears nothing that I need because it traced the
open server information.
Thank you for your information in advance.

what is the log content of you isql command ? Do you use
the -t option in the isql command ? I experienced a bad
trip with this option, backup succeeding randomly because
of timeouts ...

Thank you for your post

but My isql was not use -t options

Any ideas?

[Emmanuel Torre]

ok but what is the log contents of you isql command ?

Post by unknown

Post by Emmanuel Torre

Post by unknown
Hi all,
I faced problem that sometimes when I backup database
by dump database
It appears to be hung.
and the dump file was not succeed.
But sometime it succeeds when dumping database
How should I know that what's the problem that I faced?
May be some trace flag will help me know somethings?
Now I used -T6 in the backupserver starter process.
but it appears nothing that I need because it traced the
open server information.
Thank you for your information in advance.

what is the log content of you isql command ? Do you use
the -t option in the isql command ? I experienced a bad
trip with this option, backup succeeding randomly because
of timeouts ...

Thank you for your post
but My isql was not use -t options
Any ideas?