Post reply

Problem - Backup with Append to file

  • June 18, 2008 at 1:06 am

    #124372

    Hi,

    i have here a schedule backup which runs daily but it keeps appending the backup to one file only..

    now, my problem is, it is(the backup file) getting bigger and if i delete the file i will lost all of my backup.

    i want to select only old backups from one file and delete it.. is it possible?!?

    did i explain my problem clear? if not please dont hesitate to ask..;p

    thanks

  • June 18, 2008 at 1:44 am

    #830243

    paksyeet (6/18/2008)

    Hi,

    i have here a schedule backup which runs daily but it keeps appending the backup to one file only..

    now, my problem is, it is(the backup file) getting bigger and if i delete the file i will lost all of my backup.

    i want to select only old backups from one file and delete it.. is it possible?!?

    did i explain my problem clear? if not please dont hesitate to ask..;p

    thanks

    There is no command or tool I'm aware of that could do this for you. It is relatively easy to write such a utility if you really really need this. See my post: http://www.sqlservercentral.com/Forums/Topic401706-149-1.aspx. Note that it would probably be a much better idea to use a single backupset per backup file in your case, maybe have N+1 physical backup files if you want to keep the last N backups, and rotate them (e.g. on Mondays back up to Monday.bak, and use the WITH INIT or WITH FORMAT in the backup command).

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • June 18, 2008 at 3:22 am

    #830269

    thanks..

    btw it is a backup file not a device nor anything..

    like backup to drive c:\databasebackup.bak blah blah NOFORMAT

    anyway.. i guess my only option is to delete the said backup file so i can free up some space then continue with my backup..

    thanks

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

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