Post reply

Restore Error due to Space Issue

  • February 3, 2011 at 3:14 am

    #388769

    Hi EveryBody,

    I need to be restored the backup.. it shows the following error.

    There is insufficient free space on disk volume

    'D:\' to create the database. The database requires 9538633728 additional free bytes, while only 9327198208 bytes are available

    D:\ drive having 8126 MB Free approximately 8.1 GB. But the database size is 177 MB only. I would very much appreciate, if any body advise me, how to fix this?

    Regards

    Balaji G

  • February 4, 2011 at 3:30 am

    #1282342

    balaji.ganga 68339 (2/3/2011)

    Hi EveryBody,

    I need to be restored the backup.. it shows the following error.

    There is insufficient free space on disk volume

    'D:\' to create the database. The database requires 9538633728 additional free bytes, while only 9327198208 bytes are available

    D:\ drive having 8126 MB Free approximately 8.1 GB. But the database size is 177 MB only. I would very much appreciate, if any body advise me, how to fix this?

    Regards

    Balaji G

    Check the file size.Where the backup has been taken ?

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • February 4, 2011 at 3:41 am

    #1282345

    The database requires 9538633728 additional free bytes, while only 9327198208 bytes are available

    But the database size is 177 MB only.

    The error is explanatory itself.

    If you convert requires kb(9538633728) and available KB(9327198208) into GB then you will come to know the problem.

    But the database size is 177 MB only.

    Database size could be 177MB but it doent mean that backup will restore your database to 177mb. At the time of backup, you need to check your mdf and ldf size.

    ----------
    Ashish

  • February 4, 2011 at 5:45 am

    #1282385

    balaji.ganga 68339 (2/3/2011)

    Hi EveryBody,

    I need to be restored the backup.. it shows the following error.

    There is insufficient free space on disk volume

    'D:\' to create the database. The database requires 9538633728 additional free bytes, while only 9327198208 bytes are available

    D:\ drive having 8126 MB Free approximately 8.1 GB. But the database size is 177 MB only. I would very much appreciate, if any body advise me, how to fix this?

    Regards

    Balaji G

    What is the size of your backup file. Try removing un-necessary files from the drive to reclaim some space.

    M&M

  • February 4, 2011 at 6:51 am

    #1282424

    Hi All,

    Thanks for all your comments.. .mdf file size is huge.. I shrunk the database. i have reclaim the space around 20GB. then i took the backup and restored it.

    Thanks a lot

    Regards

    Balaji G

  • February 4, 2011 at 7:30 am

    #1282466

    Good to see it worked.

    But shrinking the database should not be treated as solution to reduce the ldf/mdf file size. In fact you should first investigate why the database files are so huge.

    To make it more understanding, read this Gail's lovely Article :-

    http://www.sqlservercentral.com/articles/64582/

    ----------
    Ashish

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

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