SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes & Times)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Kevin van der Merwe... » SQL 2005 vs. SQL 2008 Part 1 - (Backup File...

55 posts, Page 6 of 6

«««2 3 4 5 6

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes & Times)

Rate Topic

Display Mode

Topic Options

Author

Message

SQLTIME

Posted Thursday, May 15, 2008 11:23 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, December 13, 2010 10:04 AM
Points: 144, Visits: 79

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

Kevin-458339

Posted Friday, May 16, 2008 12:34 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, April 12, 2012 1:59 AM
Points: 334, Visits: 3,135

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

Vivien Xing

Posted Friday, March 13, 2009 8:27 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 7:19 AM
Points: 1,279, Visits: 2,191

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

ashkan siroos

Posted Tuesday, September 28, 2010 7:53 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 5:15 AM
Points: 93, Visits: 230

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

Danny Ocean

Posted Tuesday, May 31, 2011 12:19 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:51 AM
Points: 1,085, Visits: 1,166

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

Keep Learning - Keep Growing !!!
http://growwithsql.blogspot.in

Thanks
Vinay Kumar

Post #1117215

« Prev Topic | Next Topic »

55 posts, Page 6 of 6

«««2 3 4 5 6

Permissions