• No, of course not. If that was the case, how would a restore ever work for a database larger than physical memory?

    They're buffers, in the normal computer science definition of the word (http://en.wikipedia.org/wiki/Data_buffer). There's nothing fancy or unique about them, they are simple buffers, the buffercount defines how many are and the buffersize defines how big they are.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass