Backup compression

• vino5786

  Right there with Babe

  Points: 743

  More actions

  September 7, 2011 at 2:20 am

  #247425

  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

• muthukkumaran Kaliyamoorthy

  SSCoach

  Points: 19026

  More actions

  September 7, 2011 at 2:45 am

  #1377837

  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

  noneed to uncompress.

  You can restore a DB backup as normal.

  ex:

  restore database dba from disk='xxxxxxxxx'

  Muthukkumaran Kaliyamoorthy
  https://www.sqlserverblogforum.com/

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  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.

• Shivrudra

  SSCrazy

  Points: 2835

  More actions

  September 7, 2011 at 3:04 am

  #1377843

  Compressed backup file is a OS physical file which is restore normally like any backup file while restoring database, there is no such a thing like uncompress backup file.

  Regards,
  Shivrudra W

• Arindam Ganguly

  Old Hand

  Points: 303

  More actions

  February 19, 2013 at 6:05 am

  #1589167

  Hi,

  I have one point to ask. I have Backup compression enabled in my SQL Server. Can I restore any uncompressed Normal Backup. For the shake of information the Server is using STandard version of SQL Server 2008 R2 with SP2.

  Please advise.

  Thanks,

  Arindam.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  February 19, 2013 at 6:34 am

  #1589178

  Arindam Ganguly (2/19/2013)

  ---

  Hi,

  I have one point to ask. I have Backup compression enabled in my SQL Server. Can I restore any uncompressed Normal Backup. For the shake of information the Server is using STandard version of SQL Server 2008 R2 with SP2.

  Please advise.

  Thanks,

  Arindam.

  Yes, backups compressed or not can be restored to any edition of SQL, but only to an equal or higher version of the original server level.