Post reply

DB and VM backup timing

  • November 11, 2021 at 2:10 pm

    Go to Answer

    #3952024

    Hello experts,

    In terms of backups, we have database backups set up, which I am familiar with, but we also back up our Windows VMs that host SQL Servers.

    Do you know if it is good or bad to have the Windows VM backup happen at the same time as the daily database full backups? Or should one be done before the other?

    Thanks for any help.

    -- webrunner

    • This topic was modified 2 years, 5 months ago by  webrunner.

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • November 11, 2021 at 8:34 pm

    Answer

    #3952158

    For me the VM should be backed up after SQL especially if your backing up to local disk.  That way the VM backup will backup the backup files to tape/some other media/off site storage etc.

  • November 11, 2021 at 8:40 pm

    #3952159

    Thanks, Ant-Green! Much appreciated.

    -- webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • November 12, 2021 at 12:16 pm

    #3952354

    Hi,

    please choose different times for your backups. On our backups with a snapshot of VM, your database were "frozen" for some seconds. If this appears in the night, nobody cares.

    But if you choose the same time for both backups, this maybe a problem.

    Kind regards,

    Andreas

Viewing 4 posts - 1 through 3 (of 3 total)

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