Home Forums SQL Server 2014 Development - SQL Server 2014 Backup Restoring - Insufficient free space RE: Backup Restoring - Insufficient free space

  • September 21, 2016 at 4:14 pm

    #1902312

    Minnu (9/21/2016)

    Hi Team,

    Restoring SQL Server database from one server to another.

    Actual Database size is: 14.3 GB

    But while restoring getting below error.

    The database required 127533776896 additional free bytes, while only 47082643456 bytes are available.

    I have all the drives with free space of 45 GB only, how to restore the .bak.

    Please suggest

    Simple... go back to the source and see why things are so big. For example, could it be that the log file is huge because of no transaction log backups? There are a dozen other possibilities.

    If you can't resolve the size of the database at the source (which might be why you're doing a restore to begin with), then you need to find or buy more disk space, plain and simple.

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