Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup compression Expand / Collapse
Author
Message
Posted Wednesday, September 7, 2011 2:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 10:37 PM
Points: 46, Visits: 433
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
Post #1170891
Posted Wednesday, September 7, 2011 2:45 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 28, 2014 11:44 AM
Points: 1,155, Visits: 4,641
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

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1170901
Posted Wednesday, September 7, 2011 2:46 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 2:55 AM
Points: 1,101, Visits: 5,280
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.
Post #1170903
Posted Wednesday, September 7, 2011 3:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 8, 2013 9:46 AM
Points: 101, Visits: 842
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
Post #1170910
Posted Tuesday, February 19, 2013 6:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 9:44 PM
Points: 6, Visits: 207
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.
Post #1421601
Posted Tuesday, February 19, 2013 6:34 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:13 AM
Points: 5,227, Visits: 5,086
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.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1421612
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse