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

SQL Server 2008 R2 Features Expand / Collapse
Author
Message
Posted Monday, March 14, 2011 7:08 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 7:10 PM
Points: 1,786, Visits: 1,111
Duncan Pryde (3/14/2011)
Abi Chapagai (3/13/2011)
Koen Verbeeck (3/13/2011)
Very nice question, thanks.


Thank you all for the comments. This is my first question.


I look forward to your second one!

Duncan


Thanks Duncan, I will try to post another question.
Post #1077676
Posted Monday, March 14, 2011 7:47 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 2:51 PM
Points: 666, Visits: 480
I was reading through all this features yesterday. It was an easy one for me.
Nice question. Thanks
Post #1077702
Posted Monday, March 14, 2011 1:20 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:34 AM
Points: 2,011, Visits: 2,013
A while ago I implemented an SQL Server job that uses 7zip to compress backups after they run. I've been getting between 80 and 85 % compression.

When we upgrade I'll have to test out the built-in compression to see if the percentage is comparable. Either way the job may still come in handy in places that are slow to upgrade.
Post #1077964
Posted Monday, March 14, 2011 1:50 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:13 PM
Points: 989, Visits: 1,821
Dave62 (3/14/2011)
A while ago I implemented an SQL Server job that uses 7zip to compress backups after they run. I've been getting between 80 and 85 % compression.

When we upgrade I'll have to test out the built-in compression to see if the percentage is comparable. Either way the job may still come in handy in places that are slow to upgrade.


I can get between 30 to 90 percent compression on databases, depending upon the contents and datatypes (straight text and numbers compress VERY well). And the beauty is twofold -- one, it's only one step instead of two, and the one step is not much longer if at all longer than the original first step of making the backup in the first place, so you might cut your time in half in theory. Second, it doesn't require the Agent to run a command line utility. We did that in 2000 with WinRar and I found that upon occasion WinRar would hang, and so the job would hang and never complete or error out. Not an issue here. We have moved to compressing ALL 2008 backups as a matter of course; even if it is not much space savings, it is some and minimal overhead. A truly great feature to have.
Post #1077975
Posted Monday, March 14, 2011 2:05 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:34 AM
Points: 2,011, Visits: 2,013
jeff.mason (3/14/2011)
...I can get between 30 to 90 percent compression on databases, depending upon the contents and datatypes (straight text and numbers compress VERY well)...


Thanks! That will save me some research time.

I'll keep the job around for older systems.

Never had a problem with 7zip hanging. Although it's not directly called from the agent. I'm using the agent to call a VBScript that handles business rules for archiving the zip files and deleting the older ones per the specified requirements. The script calls 7zip and also does more logging than the job. Haven't had any issues with this method yet...
Post #1077981
Posted Monday, March 14, 2011 10:59 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:50 AM
Points: 21,310, Visits: 14,994
Nice question indeed. Many of us could use more of those "enterprise" features in the standard edition.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1078124
Posted Thursday, March 17, 2011 11:35 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, July 7, 2014 4:54 AM
Points: 492, Visits: 359
The question could be slightly more specific. Backup compression existed before SQL Server 2008 R2 Standard Edition was released (it existed in SQL Server 2008 Enterprise).

Ben
Post #1079905
Posted Thursday, March 17, 2011 1:52 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
ben-564110 (3/17/2011)
The question could be slightly more specific. Backup compression existed before SQL Server 2008 R2 Standard Edition was released (it existed in SQL Server 2008 Enterprise).


Really? More specific than "Which of the following is one of the new features of SQL Server 2008 R2 Standard Edition."? (I probably would have used in instead of of.)
Post #1080002
Posted Thursday, March 17, 2011 2:39 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 7:10 PM
Points: 1,786, Visits: 1,111
I think question is clear because I have mentioned SQL Server 2008 R2 Edition. I know backup compressions existed in SQL Server 2008 EE but not in SQL Server 2008 Standard Edition. Since we have this feature in SQL Server 2008 R2 Standard Edition and I wanted to highlight this feature.
Post #1080037
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse