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 Wednesday, May 7, 2008 2:17 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 11:04 PM
Points: 335, Visits: 3,172
Hi

That does sound about right. If the SQL Engine has the compression built in then it would be crazy to have diffirent versions or limitations based on the edition.

But yes having data compression on the fly when storing data to the datafile is still seen as a new exciting feature and would more than likely be a selling feature for Enterprise edition.

But the good news is that this technology now exists and it should eventually become a standard feature for all editions - we just hope that this does not take too lon to get to us.
Post #496129
Posted Wednesday, May 7, 2008 5:02 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:09 AM
Points: 5,338, Visits: 1,385
I also agree that it should available in 2-3 versions. :)


Post #496200
Posted Wednesday, May 7, 2008 6:24 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 17, 2008 4:31 PM
Points: 31, Visits: 15
Sorry Michael - refer to this document published by Microsoft which clearly states that backup compression is Enterprise only

[url=http://download.microsoft.com/download/2/d/f/2df66c0c-fff2-4f2e-b739-bf4581cee533/SQLServer%202008CompareEnterpriseStandard.pdf][/url]

THat's why we're looking at RedGate SQL Backup as an alternative

Cameron
Post #496799
Posted Thursday, May 8, 2008 1:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 29, 2010 8:07 AM
Points: 36, Visits: 71
The document does say subject to change; and it doesn't say when it was compiled ( which is a bit annoying).
I will send an email to my microsoft contact to see he can confirm anything has changed.
Be a real shame, but I wonder if it is on purpose to keep the likes of red-gate products available..
does look purely marketing rather than that only enterprises would need to compress backups.
Will post a reply if I get one from MS contact.

Reply is :
"Both backup compression and data compression are enterprise edition features. Restoring a compressed backup can be done using any edition.
Usually the idea is that if it’s a scalability or availability related feature then its EE."

It must have been the restore bit i remembered.


Post #496919
Posted Thursday, May 8, 2008 2:03 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 2, 2012 7:05 AM
Points: 75, Visits: 446
Kevin,
Please state which edition(s) of SQL 2008 include the feature you are discussing in the series.
Thanks.



Post #497414
Posted Thursday, May 8, 2008 11:40 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 11:04 PM
Points: 335, Visits: 3,172
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
Post #497577
Posted Sunday, May 11, 2008 4:17 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 27, 2009 4:54 PM
Points: 57, Visits: 113
Anybody done any third party compression vs. sql2008 compression?
Post #498499
Posted Sunday, May 11, 2008 6:16 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 17, 2008 4:31 PM
Points: 31, Visits: 15
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
Post #498507
Posted Monday, May 12, 2008 12:55 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 2, 2012 7:05 AM
Points: 75, Visits: 446

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.



Post #499048
Posted Thursday, May 15, 2008 11:17 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, December 13, 2010 10:04 AM
Points: 144, Visits: 79
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
Post #501521
« Prev Topic | Next Topic »

Add to briefcase «««23456»»

Permissions Expand / Collapse