Post reply

Ola's Maintenance Solution- differential backups have .bak instead of .dif - will this cause any problems with restore

  • January 8, 2015 at 5:59 am

    #302198

    Hi All

    I am using Ola Hallengren's Maintenance Solution. I noticed that the differential backups have the .bak extension. Does anyone know how I could change this to a .dif extension?

    Thanks

    Kathy

  • January 8, 2015 at 6:04 am

    #1768754

    i would put the full or diff identifier in the filename

    i.e. mysqlbackup_full_20150106_1120.bak

    mysqlbackup_diff_20150106_1130.bak

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • January 8, 2015 at 6:26 am

    #1768762

    in the procedure you have:

    SELECT @CurrentFileExtension = CASE

    WHEN @BackupSoftware IS NULL AND @CurrentBackupType = 'FULL' THEN 'bak'

    WHEN @BackupSoftware IS NULL AND @CurrentBackupType = 'DIFF' THEN 'bak'

    WHEN @BackupSoftware IS NULL AND @CurrentBackupType = 'LOG' THEN 'trn'

    WHEN @BackupSoftware = 'LITESPEED' AND @CurrentBackupType = 'FULL' THEN 'bak'

    WHEN @BackupSoftware = 'LITESPEED' AND @CurrentBackupType = 'DIFF' THEN 'bak'

    WHEN @BackupSoftware = 'LITESPEED' AND @CurrentBackupType = 'LOG' THEN 'trn'

    WHEN @BackupSoftware = 'SQLBACKUP' AND @CurrentBackupType = 'FULL' THEN 'sqb'

    WHEN @BackupSoftware = 'SQLBACKUP' AND @CurrentBackupType = 'DIFF' THEN 'sqb'

    WHEN @BackupSoftware = 'SQLBACKUP' AND @CurrentBackupType = 'LOG' THEN 'sqb'

    WHEN @BackupSoftware = 'SQLSAFE' AND @CurrentBackupType = 'FULL' THEN 'safe'

    WHEN @BackupSoftware = 'SQLSAFE' AND @CurrentBackupType = 'DIFF' THEN 'safe'

    WHEN @BackupSoftware = 'SQLSAFE' AND @CurrentBackupType = 'LOG' THEN 'safe'

    END

    so i would say thats what you want to have a look at

  • January 8, 2015 at 6:26 am

    #1768763

    Nah. You can call your backup files .doc if you want to. They'll still work fine.

    Don't do that though.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • January 8, 2015 at 6:27 am

    #1768764

    And I'm with Perry. I'd use .bak for all sorts of backup files, but differentiate them in the name.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • January 8, 2015 at 6:56 am

    #1768772

    Thanks everyone!

  • January 8, 2015 at 8:41 am

    #1768804

    plamannkathy (1/8/2015)

    Hi All

    I am using Ola Hallengren's Maintenance Solution. I noticed that the differential backups have the .bak extension. Does anyone know how I could change this to a .dif extension?

    Thanks

    Kathy

    This question does indicate that you have some huge problems just waiting to bite you in the future. And, no, I don't mean this as a personal slam but it's a very strong indication that you haven't actually tried doing a restore and that you might not be as familiar with backups and restores as you need to be.

    I strongly recommend that you do a deep dive on both and that you start practicing doing restores and then setup some automation to do a test restore every day if your DB is small enough and a least once a month if your DB is huge.

    --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)

  • January 9, 2015 at 3:59 am

    #1769011

    Grant Fritchey (1/8/2015)

    And I'm with Perry. I'd use .bak for all sorts of backup files, but differentiate them in the name.

    Or .TRN for tran log backups. The Microsoft provided defaults of .BAK and .TRN work just fine no need to re invent the wheel

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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