Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2012-10-22 : 14:23:31
|
| Hi,We are currently using backup compression in SQL Server 2008 and space and CPU utilization is fine but needs some improvements without buying different hardware but was trying different 3rd party tools like litespeed etc but did not see any noticeable performance gain, Is anyone using any 3rd party tool that is working better than SQL Server default backup with compression? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-22 : 15:18:51
|
| Redgate also has a backup compression product, you can try that. Based on my tests (a few years ago) each product was nearly identical in CPU utilization/time vs. compression ratio, the higher compression took quite a bit longer. The middle settings were very close to native backup compression too. None of them compress as well as WinZip/WinRar/7zip at their highest settings, but those tools also take much longer to get the best compression. They also don't compress already compressed backups. |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-10-23 : 09:35:07
|
| Performance in terms of speed or compression? Speed -> faster disks maybe? SSD's?Compression -> more cpu- LumbagoMy blog-> http://thefirstsql.com |
|
|
|
Miss_Paris_H
Starting Member
1 Post |
Posted - 2012-10-26 : 09:46:50
|
| Our infrastructure guys are looking at a solution that leverages VSC to backup just the mdf and ldf files and I'm very nervous.Can anyone point me at any resources that can demonstrate where this might fail? And conversely if there are times it can fail but they can be avoided, what checks do we need to have in place?Thanks for any input! |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2012-10-26 : 10:20:26
|
quote:
Originally posted by Miss_Paris_H
Our infrastructure guys are looking at a solution that leverages VSC to backup just the mdf and ldf files and I'm very nervous.Can anyone point me at any resources that can demonstrate where this might fail? And conversely if there are times it can fail but they can be avoided, what checks do we need to have in place?Thanks for any input!
That is a very risky approach to backups. There is no guarantee that you will be able to recover a database from backups of the .mdf and .ldf files.Also, it makes point-in-time recovery impossible, as opposed to a combination of full backups and transaction log backups.It’s best to stick to something that works with backups. The native backup compression is probably your best option.What is the problem you are having that you are trying to solve?CODO ERGO SUM |
|
|
|
|
|
|
Any 3rd party tool better than native backup