• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 483
  • Last Modified:

compressing transaction log

is trasaction log compression before shipping in SQL Server 2008 compared to SLQ Server 2005? first , can it be done in 2005?
0
crishna1
Asked:
crishna1
  • 6
  • 3
  • 3
  • +1
3 Solutions
 
chapmandewCommented:
not really...you will need to shrink it if it gets too big.  BUT, if you do frequent enough log backups, you shoudln't run into any problems.
0
 
crishna1Author Commented:
from your responce,  can i assume sql server 2005 or 2008 do not compress? or compression in 2008 is no superior than 2005?
say the database size would grow to 1 TB and i'm planning on backingup the log every 3-4 hours.

also, you mentioned to shrink the log, i guess this comes as an option in SSMS, is it?
 
0
 
chapmandewCommented:
you can right click on the db and go to tasks and shrink it from there.

I don't think log compressions is an option in 2008...data compression is, but log compression...it is ssequential data...really nothing to compress.

If you plan on your log file getting big, do more frequent log backups.

Also, read this article I wrote about it.
http://blogs.techrepublic.com.com/datacenter/?p=448
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
dportasCommented:
Log compression is supported in SQL Server 2008 Enterprise but not in 2005.
http://technet.microsoft.com/en-us/library/ms188168.aspx

0
 
chapmandewCommented:
just to be clear, David you're referring to compressing the log backups, and not the log files themselves, right?
0
 
crishna1Author Commented:
is it supported only on Enterprise Edition? what about Standard Edition?
0
 
crishna1Author Commented:
i am reffering to compressing log backup before shipping it, hope i am clear.
0
 
Anthony PerkinsCommented:
I suspect this was the link that was intended previously:
Backup Compression (SQL Server)
http://technet.microsoft.com/en-us/library/bb964719.aspx
0
 
dportasCommented:
Yes. For log shipping it's the size of the backup that matters. You don't need to do anything with the files.
0
 
chapmandewCommented:
ah...sorry, thought you meant the log itself. Sure, you can compress both backup types, but with Enterprise Edition in 2008 only.
0
 
chapmandewCommented:
Yep..but unless I just missed it, I didn't see where the author has referred to using log shipping.
0
 
dportasCommented:
I read "before shipping" and assumed that's what he meant.
0
 
Anthony PerkinsCommented:
Here is a good article on Backup Compression using SQL Server 2008
Backup compression in SQL Server 2008
http://blogs.techrepublic.com.com/datacenter/?p=433

:)
0
 
chapmandewCommented:
david, you're probably right...I just missed it.

Thats a good looking article..  :)
0
 
Anthony PerkinsCommented:
I thought you would get a kick out of that. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 6
  • 3
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now