Home Forums SQL Server 2008 SQL Server 2008 - General Backup compression RE: Backup compression

  • September 7, 2011 at 2:46 am

    #1377839

    vino5786 (9/7/2011)

    Hi Friends,

    Just wondering how do we uncompress the backup taken with "WITH COMPRESSION " option in SQL Server 2008

    Also how do we restore the compressed full backup to the database.

    Thanks in advance

    Why do you want to umcompress?

    Restore is done as usual. No need to do anything special.

    Note: compresses backup can be taken only in EE or higher, but you can restore it in any edition.