Post reply

database backup problem

  • October 25, 2010 at 5:28 am

    #225436

    Hi

    I have a maintenance plan that does a full backup of our database on a daily basis. The trouble is that as the database is quite a large the disk space runs out quite quickly. Is there anyway to get the maintenance plan to overwrite the last backup rather than create a new backup file?

    Thanks

    Matt

  • October 25, 2010 at 6:04 am

    #1241522

    you can delete old backups using maintenance plan.

    blog: http://sarveshsingh.comTwitter: @sarveshsing

  • October 25, 2010 at 9:07 am

    #1241651

    More options:

    - After the backup completes, add a step to move it to tape or another drive with more space.

    - Purchase 3rd party backup software that will compress the backups.

    - Direct the backup to another drive in the first place. This is a bit riskier depending on the stability & speed of your network.

  • October 25, 2010 at 9:14 am

    #1241657

    @ matt

    You can delete old backup files on a daily basis too

    delete files older than 1 day

    by selecting tht option in the step" maintenance cleanup task"

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • October 25, 2010 at 9:16 am

    #1241659

    If you want to delete the old backup first because of space constraints, make sure you have it on another server. Because your server will choose to fail right between the deletion and the next backup at some point.

  • October 25, 2010 at 2:18 pm

    #1241900

    Thanks for your suggestions guys 😉

  • October 27, 2010 at 3:57 am

    #1242728

    Steve Jones - SSC Editor (10/25/2010)

    make sure you have it on another server. Because your server will choose to fail right between the deletion and the next backup at some point.

    I didnt get this , Steve ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • October 27, 2010 at 4:02 am

    #1242730

    Steve means that you should move the old backup to another server, then do the new back up.

    When the new backup is complete you can then delete the old backup from the other server because the chances are if you delete the old backup first the server will go tits up before you get a chance to do a new back up.

  • October 27, 2010 at 7:59 am

    #1242894

    Yes, what Matt said. If you delete the old backup first, and you don't have another copy, you are at a point in time when you cannot recover if the database fails.

    And Mr. Murphy will likely break the database at that point.

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

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