Can''t Restore Bakup of size 3.97GB

  • Dear All,

    I am facing problem of restoring a db of size 3.97GB. there is enough space in the drive around 8 GB but i am getting a message of not enough space.

    Please Help me

  • Maybe the trans.log file (the original one) is to big?

  • If you post the exact error maybe we can help.

  • Run this and see what the file sizes are.


    FROM DISK = 'backupFilePathAndName'

    If the combined file size of all the files in the backup exceed the amount of free space, you won't be able to restore.  Note that the size of the backup file is totally irrelevant here.


    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek


  • backup log file shrink log and do a backup your restore should work just

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

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