Home Forums SQL Server 2008 SQL Server 2008 - General Restore compressed backup creates 5x larger database RE: Restore compressed backup creates 5x larger database

  • March 26, 2014 at 8:06 am

    #1700298

    You said the production DB has initial size of 15GB, what's the actual size of the data file on disk?

    Edit: Native backups? What's the backup command? What's the restore command?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass