| Author |
Compressed database dumps?
|
|
|
| Is it ok (or advisable) to enable NT compression for the
\mssql\backup directory? I've been able to save quite a
bit of disk space doing this for my dump files. I've been
told however there could be a problem when trying to
restore from the compressed backups. I haven't seen this
but want to find out if there is an issue. I know there
are third party tools that do this on the fly. I don't see
why NT compression wouldn't work also.
Thanks
| |
| Jasper Smith 2002-11-27, 1:24 pm |
| I've used this a lot on Win2000 - never had any problems
and saves a lot of space. There are 3rd party tools to do this
one of which is SQL Litespeed
http://www.sql-server-performance.c...d_spotlight.asp
--
HTH
Jasper Smith (SQL Server MVP)
"Mike" <michael.chubbs@staples.com> wrote in message
news:1a80301c29639$4fc10fb0$8d
f82ecf@TK2MSFTNGXA02...
> Is it ok (or advisable) to enable NT compression for the
> \mssql\backup directory? I've been able to save quite a
> bit of disk space doing this for my dump files. I've been
> told however there could be a problem when trying to
> restore from the compressed backups. I haven't seen this
> but want to find out if there is an issue. I know there
> are third party tools that do this on the fly. I don't see
> why NT compression wouldn't work also.
> Thanks
| |
| Neil Pike 2002-11-27, 4:24 pm |
| Mike - no reason it wouldn't work, and whilst I've only done it when out of
space I've never had a problem so far...
> Is it ok (or advisable) to enable NT compression for the
> \mssql\backup directory? I've been able to save quite a
> bit of disk space doing this for my dump files. I've been
> told however there could be a problem when trying to
> restore from the compressed backups. I haven't seen this
> but want to find out if there is an issue. I know there
> are third party tools that do this on the fly. I don't see
> why NT compression wouldn't work also.
> Thanks
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
| |
| Mark Allison 2002-11-27, 4:24 pm |
| On 27 Nov 2002, "Mike" <michael.chubbs@staples.com> wrote the following
pearl of wisdom:
> Is it ok (or advisable) to enable NT compression for the
> \mssql\backup directory? I've been able to save quite a
> bit of disk space doing this for my dump files. I've been
> told however there could be a problem when trying to
> restore from the compressed backups. I haven't seen this
> but want to find out if there is an issue. I know there
> are third party tools that do this on the fly. I don't see
> why NT compression wouldn't work also.
> Thanks
The only drawback is that the compression may not be as good as a third
party tool. I like to use gzip in a mutli-step SQL Agent job for my
backups. The other good thing is that it's free. www.gzip.org
Step1: Backup the database
Step2: gZip the backup file
Step3: Housekeep
--
Mark Allison, SQL Server MVP
http://www.allisonmitchell.com
| |
| Allan Mitchell 2002-11-28, 4:23 am |
| How about using the tool from SQLLiteSpeed. It does compression and they
claim to 80%(depends on data).
--
Allan Mitchell (Microsoft SQL Server MVP)
www.SQLDTS.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Neil Pike" <neilpike@compuserve.com> wrote in message
news:VA.00005eb4.01f58cbb@compuserve.com...
> Mike - no reason it wouldn't work, and whilst I've only done it when out
of
> space I've never had a problem so far...
>
> > Is it ok (or advisable) to enable NT compression for the
> > \mssql\backup directory? I've been able to save quite a
> > bit of disk space doing this for my dump files. I've been
> > told however there could be a problem when trying to
> > restore from the compressed backups. I haven't seen this
> > but want to find out if there is an issue. I know there
> > are third party tools that do this on the fly. I don't see
> > why NT compression wouldn't work also.
> > Thanks
> >
>
> Neil Pike MVP/MCSE. Protech Computing Ltd
> Reply here - no email
> SQL FAQ (484 entries) see
> http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
> (faqxxx.zip in lib 7)
> or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> or www.sqlserverfaq.com
> or www.mssqlserver.com/faq
>
|
|
|
|