Solved

sql 2005 backup compression

Posted on 2011-02-22
3
670 Views
Last Modified: 2012-05-11
i have been asked to send a backup of a database using sql 2005.  We generally use redgate tools for compression.
but does sql 2005 have built in compression?  I cannot find it if there is. anyone know?
0
Comment
Question by:Amanda Walshaw
3 Comments
 
LVL 5

Accepted Solution

by:
robertg34 earned 500 total points
ID: 34957407
No.  Sql 2005 has no built in compression options.  Red Gate is a good tool for that.  Compression is introduced in sql 2008.  
0
 
LVL 13

Expert Comment

by:agarwalrahul
ID: 34957739
0
 

Author Closing Comment

by:Amanda Walshaw
ID: 34958106
thought it was the case
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Pivot Query Problem 9 41
How to simplify my SQL statement? 14 52
Query to Add Late Tolerance 10 67
Anyway to make these 2 SQL statements into one? 13 38
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now