SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2008 R2 Features


SQL Server 2008 R2 Features

Author
Message
Abi Chapagai
Abi Chapagai
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2058 Visits: 1127
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.
Surii
Surii
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1027 Visits: 489
I was reading through all this features yesterday. It was an easy one for me.
Nice question. Thanks
Dave62
Dave62
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4156 Visits: 2935
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.
jeff.mason
jeff.mason
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5193 Visits: 2137
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.
Dave62
Dave62
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4156 Visits: 2935
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... :-)
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)SSC Guru (145K reputation)

Group: General Forum Members
Points: 145179 Visits: 18652
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Learn Extended Events

ben-564110
ben-564110
Say Hey Kid
Say Hey Kid (698 reputation)Say Hey Kid (698 reputation)Say Hey Kid (698 reputation)Say Hey Kid (698 reputation)Say Hey Kid (698 reputation)Say Hey Kid (698 reputation)Say Hey Kid (698 reputation)Say Hey Kid (698 reputation)

Group: General Forum Members
Points: 698 Visits: 379
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
UMG Developer
UMG Developer
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7264 Visits: 2204
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.)
Abi Chapagai
Abi Chapagai
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2058 Visits: 1127
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search