That wouldn't be enough to recover the database. If there was a long running transaction that started before the full backup did, only backing up the transaction log generated during...

select col1, sum(col2), (SELECT col3 + ', ' AS [text()]

FROM @T a

where a.col1 = b.col1

ORDER BY col3

FOR XML PATH(''))

from @T b

group by col1

Edit: Doh! Nested Loop :Whistling:

You're right, we've gone a bit off topic - thanks for the info though.

I was afraid you were going to say that 😀

There's nothing else running on the box, max server memory is set to leave 6gb for the OS and nic and...

Wilfred van Dijk (11/19/2008)

---

You probably mentioned the "... a significant amout of memory has been paged out ..." errors you'll see in the errorlog.

The solution is simple:

1) make sure the...

The answer is: Yes, I did miss something completely obvious! I got % used stats from the database before moving it to a different server. At that...