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 it
s
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 th
is
> 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:

> 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:
>