home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 17,536 of 19,505   
   Erland Sommarskog to David Greenberg   
   Re: Backups getting stuck in Sql 2008   
   07 Jul 09 08:24:10   
   
   From: esquel@sommarskog.se   
      
   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.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca