Home Forums SQL Server 2005 Backups .bak file quadrubles in size with restore RE: .bak file quadrubles in size with restore

  • October 17, 2012 at 2:30 am

    #1549906

    sean 1516 (10/17/2012)

    I'm a newbie and I'm using using SQL 2008 R2

    I have a 10GB .bak file that when I restore requires 41GB. The restore fails because I currently have insufficient disk space. I don't understand, because the original MTB file is only 12GB. The Log file is 60GB (if that's of any consequence). Can I crop the .bak file before I restore?

    You need to shrink the database before taking the backup. Other wise it will try to create the db with same size as the original databse

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]