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 «««23456

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes & Times) Expand / Collapse
Author
Message
Posted Thursday, May 15, 2008 11:23 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, September 15, 2014 11:27 AM
Points: 144, Visits: 80
If I change the backup compression in sp_configure to 1 (0 is default), will it use compression on all backups?

Thanks,

Mary



Mary Myers
Post #501525
Posted Friday, May 16, 2008 12:34 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, August 23, 2014 6:56 AM
Points: 335, Visits: 3,173
Hi Mary

It seems as if your version number is later than mine. If it is the developer version then it should work no problem.

If you change the setting and have reconfigured then on the properties of the server should display the server setting

Thanks
Kevin
Post #501795
Posted Friday, March 13, 2009 8:27 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 10, 2014 8:13 AM
Points: 1,278, Visits: 2,204
I noticed that during SQL2008 backup with compression, the backup file size is doubled until the backup is completed. For example, a database sized 10 GB with the final backup file 2 GB, the actual size (space used) during the backup is 4 GB.

This means we need double the space for the backup operation.

Does anyone experience the same? What is the story behind?
Post #675755
Posted Tuesday, September 28, 2010 7:53 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 30, 2013 5:05 AM
Points: 94, Visits: 232
It is not 20-30% for all.
my data base has 50 GB size and after compression in sql2008 , the backup file has 32GB.
and another DB has 20 GB - backup file has 12 GB....
so about 60% for some databases


Thanks and regards,
Ashkan
Post #994454
Posted Tuesday, May 31, 2011 12:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
I like this feature very much.

when i was using sql 2005, that time i was thinking about such feature. Finally Microsoft listen about it and provide it in sql 2008.

i found only two drawbacks.

1. Using more CPU.
2, While restoring database, it'll take more time other then normal backup.


But i m ok with all these... finally it's saving my drive's valuable space...




Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1117215
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse