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.