| Author |
Backup job doesn't finish.
|
|
| D Smith 2005-10-31, 8:23 pm |
| 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,
| |
| D Smith 2005-10-31, 8:23 pm |
| By database check do you mean integrity check? If so then yes I ran one and
it was successful.
"david" wrote:
[color=darkred]
> 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:
>
|
|
|
|