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

Question

Post reply

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

Viewing 10 posts - 46 through 54 (of 54 total)

You must be logged in to reply to this topic. Login to reply

Kevin-458339 SSCrazy Points: 2717 More actions · Answer 1

Hi

The install file is called: SQL2008_DEV_CTP3_Nov_ENU.exe (20 Nov 2007)

SQL 2008 Developer Edition CTP3 November 2007

Version Number = 10.0.1075

Thanks

Kevin

Gareth-313301 Say Hey Kid Points: 691 More actions · Answer 2

Anybody done any third party compression vs. sql2008 compression?

cameron.gibbs Valued Member Points: 57 More actions · Answer 3

I've only used the Red Gate SQL Backup - it's compression is very good and you can vary the level of compresison, but I haven't had the chanec to compare to SQL 2008 compression yet

Cameron

JStiney Say Hey Kid Points: 671 More actions · Answer 4

Is anyone using Symantec Backup Exec™ Continuous Protection, Server Continuous Protection for Microsoft® SQL Server Databases to replace their SQL Server backups and if so how does it compare to Redgate or Litespeed?

We expect to be using the Continuous Protection Server, but initially just to protect our SQL Server backup files. We have not heard much about anyone using the product to replace SQL Server backups, and possibly log backups, too. But it does sound interesting.

SQLTIME SSC Veteran Points: 212 More actions · Answer 5

What download of SQL2008 are you using for your backup example? My Feb CTP is 10.0.1300 - will your example work with the Feb. CTP?

Thanks,

Mary

Mary Myers

SQLTIME SSC Veteran Points: 212 More actions · Answer 6

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

Kevin-458339 SSCrazy Points: 2717 More actions · Answer 7

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

Vivien Xing SSChampion Points: 12297 More actions · Answer 8

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?

ashkan sirous SSCrazy Points: 2733 More actions · Answer 9

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

Best Regards,
Ashkan

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 10

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