• This topic has 2 replies, 2 voices, and was last updated November 9, 2018 by Joseph K.

SQL Logging Options

  • Joseph K
    October 23, 2018 09:51:03 PM

    We are using the replication piece of Zerto only (no Zerto Backup). A question arose whether or not we should use the Full logging option in SQL or the simple logging option in SQL. My understanding is that the Full logging gives you a better chance at data recovery. Since Zerto is running every second, there is no chance to run the VSS sql writer to quiese the data and make sure that all parts of the transaction are written to disk. If we had an unexpected loss of power or network, would the vm recovery better with the Full or with the Simple logging ?

    According to Microsoft technet, Full logging lets you recover to a point in time, where as Simple only lets you recover to the last backup the night before. Love to hear your comments / experience.

    Ryan S
    November 9, 2018 06:24:55 PM

    Hi Joseph,

    Have you checked out the SQL Best Practice Guide?

    http://s3.amazonaws.com/zertodownload_docs/Latest/SQLBestPractices.pdf

    Joseph K
    November 9, 2018 09:14:56 PM

    Ryan

    Looked it over and it did not answer the question that I posted. However the idea of putting the page file and temp DB on a different disk is very interesting. I want to know in the SQL logging options if FULL or SIMPLE is better for zerto. Here is an article from Microsoft. It would seem to suggest full logging is better.

    https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server?view=sql-server-2017

    Thanks -Joseph

You must be logged in to create new topics. Click here to login