none
Backups RRS feed

  • Question

  • I am running sql server 2012 with latest sp on win server 2012 on a physical machine.  I am thinking datto backup system to perform online image backup.  They are claiming their engine is built into the kernel and therefore is able to capture the current state of the machine.  I always understood that the right way to do backups for point-in-time recovery is through transaction log backup.  Is it safe to take an image backup and assume that once the image is restored, the machine is going to pick up where it left off?  Are there issues with using image method?

    Thanks in advance

    Friday, August 28, 2015 1:31 AM

Answers

  • The snapshot backup is image so ofcourse as you said it wont provide you PIT recovery. If there is heavy  transaction running while you took disk backup there wont be information about it. So you might always not get "Where you left it"

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    • Marked as answer by rgelfand Friday, August 28, 2015 12:25 PM
    Friday, August 28, 2015 3:26 AM
    Moderator

All replies

  • Hi

    I hope you are trying to take disk image of a drive on which SQL Server is running (databases are on the drive and it has ldf, mdf, and ndf files).

    It will take snapshot of Disk on that particular time.

        

    Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::

    Friday, August 28, 2015 2:32 AM
  • The snapshot backup is image so ofcourse as you said it wont provide you PIT recovery. If there is heavy  transaction running while you took disk backup there wont be information about it. So you might always not get "Where you left it"

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    • Marked as answer by rgelfand Friday, August 28, 2015 12:25 PM
    Friday, August 28, 2015 3:26 AM
    Moderator
  • You need to consult that image backup documentation. If te backup sw uses supported measures, then this is supported. And it is possible to produce traditional log backup *based on such a snapshot backup*. Whether your backup software does this is a different question.

    Tibor Karaszi, SQL Server MVP | web | blog

    Sunday, August 30, 2015 6:45 PM
    Moderator