Post reply

with format in backup command

  • November 9, 2011 at 7:21 am

    #247660

    Hi,

    I want overwrite the previous backup files in my backup set ..i can't use WITH INIT (backup files retention period not completed)...

    If i used WITH FORMAT option it couldn't overwrite the all the backup files in backupset ..But the new backup file is appending in backup set when i try to query select * from backupset...

    I shall be thankful if someone give me idea about the same...

    Thanks to all

  • November 9, 2011 at 8:34 am

    #1405260

    I think overwriting backups is a bit dangerous... if the proverbial "lights go out" in the middle of all that, you could lose both backups. My recommendation is to do a backup, verify that its good, verify that the older backup actually lives on tape somewhere, then delete the older backup.

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

  • November 9, 2011 at 11:26 pm

    #1405521

    As per my requirement i don't want to keep the old backup files in my backupset..so how can i overwrite those backupfies in backup set.I have tried WITH FORMAT option but still appending...

  • November 10, 2011 at 12:17 am

    #1405544

    Every time will u take backup through query?

    u can create a maintenance plan for backup and select the retention period u required?

    If u wants to maintain for last two days backup u can set the retention period for two days in maintenance plan.

    Hope this helps to u...

  • November 10, 2011 at 5:58 am

    #1405675

    rocky@123 (11/9/2011)

    As per my requirement i don't want to keep the old backup files in my backupset..so how can i overwrite those backupfies in backup set.I have tried WITH FORMAT option but still appending...

    Understood. I'm suggesting that your requirement could leave you in serious trouble someday.

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

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

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