Post reply

Log backup chain

  • April 21, 2018 at 11:18 am

    #410449

    Good Morning Experts,

    We have backup jobs scheduled(full, differential and tlog) using Idera SQLSafe and they are running as per their schedule. However, a user has taken a full backup of database. What impact will this have? Will it break the log backup chain? Can this cause any issues. If I take another full backup, will log backup chain gets restarted?

  • April 23, 2018 at 5:14 am

    #1987862

    If it wasn't a copy-only full backup (you can check this in the backup history) then it will have reset the differential bitmap. If you have all of the backup files (and if you can mix native backups with Idera backups) then theoretically you're fine, but if the user deletes that backup file or if they can't be combined in a restore, you could be in trouble. If there's any doubt, take another full backup. (Disclaimer: I am very cautious.)

  • April 23, 2018 at 6:24 am

    #1987873

    Beatrix is right - this could affect your differential backups.  But it won't break your log backup chain.  Now you've come through this unscathed, this would be a good opportunity to review who has access to make backups.

    John

  • May 2, 2018 at 6:09 pm

    #1989011

    I know this post is old but why the heck does a user have enough privs to backup a database?  Such things can affect more than just your log file chain... it could affect your career.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • May 2, 2018 at 9:43 pm

    #1989027

    Jeff Moden - Wednesday, May 2, 2018 6:09 PM

    I know this post is old but why the heck does a user have enough privs to backup a database?  Such things can affect more than just your log file chain... it could affect your career.

    Jeff, instead of solving the issue , why do you always think about why the issue happened in first place. First solve the issue and then think why it happened.

  • May 3, 2018 at 2:13 am

    #1989035

    coolchaitu - Wednesday, May 2, 2018 9:43 PM

    Jeff Moden - Wednesday, May 2, 2018 6:09 PM

    I know this post is old but why the heck does a user have enough privs to backup a database?  Such things can affect more than just your log file chain... it could affect your career.

    Jeff, instead of solving the issue , why do you always think about why the issue happened in first place. First solve the issue and then think why it happened.

    Are you serious?  The issue is already resolved (see Beatrix's comment and mine before Jeff's), and so it's entirely appropriate to turn one's attention to preventing its recurrence.

    John

  • May 3, 2018 at 2:17 am

    #1989037

    Absolutely. You have to look at the whole picture or you just end up "fixing" the same problem over and over again.

Viewing 7 posts - 1 through 6 (of 6 total)

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