restore file space

  • My backup file size is about 31gig, but when I try to restore on another server prompted to have 75gig on destination server. Have full recovery on source server. Any idea why that much space requirement on destination server !

    Thanks in advance.

     

  • Most likely this is because your database has 75 gigs allocated to it.  If you have 75 gigs allocated for your tlog and data file, when you restore it will try to allocate this much space.  The backup file contains only the space that is used in your data files however on restore you need the full db and tlog size available.

    Please correct me on any of this if anyone disagrees.

  • Actually do not have that much in allocation !

    Other ideas !

  • Try creating the database first and set the size to 35 Gig, then when restoring under the options tab check the option to Force restore over existing database

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

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