Post reply

Backup database to disk for insufficient disk space

  • April 20, 2017 at 1:49 pm

    #322975

    I am facing trouble for database full backup to my local disk as there is no sufficient space in any of the disk drives.

    Please suggest me the best possibilities to complete the backup.

    Thanks so much in advance.

  • April 20, 2017 at 2:00 pm

    #1939190

    Back up to a different media. For example an external storage device or a network device. Otherwise create more space on the location you are trying to back up to.

    If you are using 2008 Enterprise, then you could set the backup to use COMPRESSION.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • April 20, 2017 at 3:20 pm

    #1939208

    Check for old backups (according to your DR plan) that can be deleted, as well.

    --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 3 posts - 1 through 3 (of 3 total)

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