From: davidgr@iba.org.il   
      
   Erland Sommarskog wrote:   
   > David Greenberg (davidgr@iba.org.il) writes:   
   >   
   >>We've just upgraded from Sql 2000 to 2008.   
   >>I designed backups in maintenance plans for our databases and run the   
   >>various subplans as different steps in a job.   
   >>The backup job keeps on getting stuck, randomly, on the backup of   
   >>different databases each time. The job doesn't fail, its just stuck.   
   >>There are no other users working on this server since I am still setting   
   >>things up. The status of the job in the job activity monitor in   
   >>executing on the step of the database it is stuck on.   
   >>Anyone here know of this problem ?   
   >   
   >   
   > Never heard about it. Have you checked the SQL Server error log? The   
   > Windows event log?   
   >   
   > To what do you back up? Local disk? SAN storage? Tape?   
   >   
   > My gut reaction is that you have a hardware problem of some sort.   
   >   
   >   
   Thanks for your answer and advice to check things other than the backup.   
   I discovered that a preliminary process to the backup that had run fine   
   on 2000 was acting flakey on 2008 and was sometimes getting stuck and   
   "hanging" which prevented the backup from continuing.   
   Thanks again   
   David Greenberg   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)