Post reply

Backup size is 12 GB and on restoration it requires 84 gb

  • January 4, 2012 at 5:18 am

    #254285

    Hi,

    My db backup size is 12 GB and on restoration it requires 84 gb.

    How could it be possible?

    Thanks

  • January 4, 2012 at 5:25 am

    #1428212

    Datafile + log files = 84 Gb.

    Backup only copies non-empty page. But the restore makes a perfect exact copy of the db as it was, including the size.

    No way around that aside from restoring somewhere, then shrink, then backup again.

    1 TB usb drives are super cheap nowadays, good way out of this issue (assuming only dev/test work).

  • January 4, 2012 at 5:31 am

    #1428213

    My mistake..Compress backup is enable.

    Its fine..

    Thanks

  • January 4, 2012 at 5:33 am

    #1428216

    Well there's that too! 😀

  • January 4, 2012 at 8:45 am

    #1428383

    forsqlserver (1/4/2012)

    My mistake..Compress backup is enable.

    Its fine..

    For future reference the following tools can help to provide info about a sql server backup file

    RESTORE FILELISTONLY

    RESTORE HEADERONLY

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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