Is this an in-place upgrade? If so make sure you opt to include the backward compatibility options, then you will get a 'legacy' section in SSMS which will include...

any chance sql agent just wasn't running at the time?

cross post,

pls reply to http://www.sqlservercentral.com/Forums/Topic629528-391-1.aspx

no more cross posts pls op especially as you are using SQL 2008!

cross post, pls answer via

http://www.sqlservercentral.com/Forums/Topic629528-391-1.aspx

OP pls confirm version you are using is 2008.

sounds like a server under stress problem caused by the app. This may help

http://support.microsoft.com/default.aspx?scid=kb;en-us;319892

next time it happens run sp_who2 to get info on processes running, I would expect there to...

SQLBOT (1/3/2009)

---

george sibbald (1/3/2009)

---

Hmmm, page\sec way too high. This value can be thrown out though by processes such as backing up large files to tape, as these really thrash the...

Hmmm, page\sec way too high. This value can be thrown out though by processes such as backing up large files to tape, as these really thrash the memory, so check...

when using AWE the value shown for sql server memory in task manager is incorrect, use the value from perfmon.

I would also set the /3GB switch in the boot.ini to...

possibly this bug?

http://support.microsoft.com/kb/899761

If I remember rightly the original release of SP4 contained this flaw, so it was re-released, so where did you get your SP4 executable from? Presumably you only...

try adding a performance alert to kick off your trn log backup job based on percentage log space used, then as log fills (at any time) it will automatically back...

is this a secondary database in a log-shipping set up? If it has been restored with standby option, try

restore database test with recovery. ...

I would say the root cause is shortage of memory., or an explicit limit has been specified for the number of locks that can be taken out. Each lock uses...

Happy christmas and a DB corruption free 2009 to all SQL DBAs.:)

...much better info on the build versions tham my post...........................

no, sorry, language barrier, by out I mean its been released. you want the x86...