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

  • 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.