Freeze IO

  • Comments posted to this topic are about the item Freeze IO

  • Good question on an undocumented(?) command, thanks.

    ...

  • This was removed by the editor as SPAM

  • Good to know!

    😀

  • use at your peril I guess?

    Are these the commands used by hardware based backup solutions?

    ---------------------------------------------------------------------

  • This was removed by the editor as SPAM

  • Never knew of it. Thanks, Steve for sharing.

  • When was this introduced? We're on 2008R2. Is there "documentation" somewhere of the undocumented DBCC commands for 2008R2?

  • My first question of the day, yahoo.

  • HappyGeek (5/24/2016)


    Good question on an undocumented(?) command, thanks.

    Yes, undocumented

  • george sibbald (5/25/2016)


    use at your peril I guess?

    Are these the commands used by hardware based backup solutions?

    don't think so. Those use the VDI interface, which doesn't freeze IO, but rather allows the product capture log records for changes.

  • George Vobr (5/25/2016)


    Never knew of it. Thanks, Steve for sharing.

    Me, either. It was a surprise to read about it and try it.

  • Steve Jones - SSC Editor (5/25/2016)


    george sibbald (5/25/2016)


    use at your peril I guess?

    Are these the commands used by hardware based backup solutions?

    don't think so. Those use the VDI interface, which doesn't freeze IO, but rather allows the product capture log records for changes.

    Looking at the server logs, we see messages identical to those created when SnapManager does its thing. Well, mostly. The Thaw message is the same but, for some reason, I'm not seeing anything in my playpit's server log for a Freeze. Hmm.

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • Ah, snaps are different. That's not a backup (usually), but a copy of the disk at a point in time. It should use the freeze to mark a stamp (somehow) that lets them copy blocks on write. They otherwise just copy blocks, but writes get priority for duplication.

  • Interesting...

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply