Post reply

Insufficient space on disk to create database

  • July 10, 2006 at 2:01 am

    #113534

    when i am tring to restore the databse this error is coming :

    There is insufficient free space on disk volume 'c:\' to create database, the database requires 7350321152 additional free bytes, while only 4023332864 bytes are available

    where sufficient disk space is available to restore the database

  • July 11, 2006 at 6:46 am

    #648435

    Hello,

    The error message is telling you the truth: You don't have enough space on the C drive to restore the database.   You will need to free up the amount required (subtract the two numbers) or restore to a different location. 

    jg

     

  • July 12, 2006 at 3:14 pm

    #648834

    If you create an empty database, but make the space allocated 10 GIG, you'll need 10 GIG to restore that backup, even though the database might be empty, or much smaller than the allocated amount. So Jeff is right, you need to r

    So it might be that the production database is reserving 7.3 gig for the database, but the data inside could be much less than that.

     I do not know how critical your application is, but another option is to shrink the database on production, and then back up the database, which would give you the smallest restoration footprint.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

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