Backup job doesn't finish.

I have a backup job that just hangs for days instead of finishing like it
should on one of our SQL servers. Its a solomon database and is using SQL
server 2000 standard. The system databases are not included in the backup its
just the solomon databases. I am not getting an error or anything because it
doesn't finish. Does anyone have any suggestions on how to troubleshoot this
sort of thing?
Thanks,
Have you done a database check to see if the database is corrupted?
I would see if the database is corrupted first before trying the backup. I
have seen this happen with databases where there are orphaned records. And
the backup will work one day and there is a corruption that causes the
database be damaged.
Thanks,
David
"D Smith" wrote:

> I have a backup job that just hangs for days instead of finishing like it
> should on one of our SQL servers. Its a solomon database and is using SQL
> server 2000 standard. The system databases are not included in the backup its
> just the solomon databases. I am not getting an error or anything because it
> doesn't finish. Does anyone have any suggestions on how to troubleshoot this
> sort of thing?
> Thanks,
|||By database check do you mean integrity check? If so then yes I ran one and
it was successful.
"david" wrote:
[vbcol=seagreen]
> Have you done a database check to see if the database is corrupted?
> I would see if the database is corrupted first before trying the backup. I
> have seen this happen with databases where there are orphaned records. And
> the backup will work one day and there is a corruption that causes the
> database be damaged.
> --
> Thanks,
> David
>
> "D Smith" wrote: