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