• janki_2886 (11/9/2010)


    @OLD Hand : If its a dumb question, then why are you wasting your precious time , in the discussion

    So peope will take careful pause the next time they post a question taken right from BOL, as we all have to do, and realize that just because something is posted literally in BOL at one point in the article does not automatically mean that it is always 100% correct, applicable, or suitable for the QOTD as stated in BOL. This is where a little research and forethought comes in handy beforehand. For example, the statement you provided from BOL does say that in a NOTE early in the article. However, if you would have read a little further down, that earlier note has a caveat to it with this statement "Snapshots of the model, master, and tempdb databases are prohibited. " BOL now amends this earlier note with this exception regardless of the recovery model. BOL does this kind of stuff all the time. IMHO, what BOL should have accurately stated in that earlier note was "All recovery models for all user and the msdb databases support database snapshots." This is why it is so important that the entire article be taken in to context when reading or quoting BOL. 😀

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"