"Sanctus" <mch***@hotmail.com> wrote in message
news:1175877761.237487.14320@y80g2000hsf.googlegroups.com...
>I have 3 20 gig databases or so that I setup and transaction log
> maintenance plan on.
>
> The transaction backups were running fine, then the other day the
> started running and never completed.  It ran for like 20 hours befores
> I finally killed the job.   There was no reason for the logs to take
> so long...all the backups before took 10 seconds and the data didn't
> change.
>
> It says it is waiting on NETWORKIO in the current activity manager.
>
> Well I killed it, and it's been rolling back for over a day now.   I
> guess there's nothing I can do while it rolls back?
>
> Also...it is causing the other FULL backup jobs to hang on the server
> and none of them are completing.
>
> Any clue why this is happening?
>
> The database has tons of sleeping SPIDS that show open transaction
> counts of 1.   I know that might causing checkpointing issues with the
> log, but why is it hanging like this?
>
> I'm not sure what else to check, since a backup job is such a simple
> transaction.  There's no logical explanation.
>
> There was a real time virus scan running when the job initially kicked
> off...it's possible that it might be the cause...the real time scan
> was stopped...the transaction still won't roll back.
>