Post reply

Help me restore my database

  • April 4, 2006 at 12:22 am

    #190068

    Hi,

    I have a production server running SQL 2000 and backing up the database on another box on a regular basis. I am running a full backup every 15 mins.

    In order for me to be sure, I restored the backup file on a non production box running SLQ 2000.

    When I do that, the backup cannot continue because of this error - "There is insufficient free space on drive c:\ to create the database". I have 2.28 GB available space. The backup is only 24MB. It is relatively a small, single database since this is only new. (4 months old).

    Is there a problem during my backup? Did I miss out something?

    Thanks

    Cesar

     

     

     

  • April 4, 2006 at 2:03 pm

    #630816

    Hello,

    the backup size is more or less the size of the data. The database size may be much bigger with a lot of extra space in the database. I did have a similar case when we were running on SQL Server 6.5. The database was 5 GB, data size was 200 MB as well as the backup size of 200 MB. We could not restore this database on the development server with 1 GB of the free space because it tried to restore to the original 5 GB. Check for the size of your production database, you may want to shrink it a little. Also check again for the free drive space on the drive C: Check if there is no quotas on your drive C: for the user who's identity is used as a security context for restore.

    Regards,Yelena Varsha

  • April 4, 2006 at 8:11 pm

    #630886

    Hi Yelena Varshal,

    Thanks for the tip. I will try this. this is a big help.

    I'll keep you posted too.

    Thank you again,

    Cesar

  • June 21, 2006 at 5:39 am

    #644986

    I have the same problem.. my 200mb file is moaning it cant be resored as it needs a bout a gig.. thing is my server has over 400 gig free space on it.. surely thats enough!?!?!

    Microsoft SQL-DMO (ODBC SQLState: 420000)" error "there is insufficient free space on disk volume c:\ to create the database. The database requires 1171193856 additional free bytes, while only 1071050752 bytes are available". RESTORE DATABASE is terminating abnormally

    Drive c: free space 417 gb / 465gb   hmmm.

    Any clues out there i'm sooooo totally stumped!!! I've backed it up from this server.. put another bigger hard drive in and trying to restore it on the same server.. so only difference really is there is now more hd space?!?! I think the os of the other one is W2003 (this new one is W2003sbs but shouldent be a problem&nbsp  Same ram (admitadly only 1 gig) same everything else!??!

  • June 22, 2006 at 5:10 am

    #645215

    its ok.. worked it out.. the SQL user had - as had most of the rest of the users had - a hard drive quota max.. Increased this and it's all fine again!!

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

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