Thursday, March 22, 2012

compression of database backups - as it is being created - options

Most if not all of the sql servers that I support are not on a SAN, and are
suffering from not having enough local space. This could be mitigated if we
were using some form of database dump compression. The optimum solution
would be one which compresses the data as it was being initially written to
the dump file.
( versus creating a full blown dump file and then running a second step to
compress it )
This compressed file would also benefit us in any subsequent copy steps,
whereby we would be copying the file to another server for stand-by purposes
.
( less network time/traffic )
If Microsoft Sql server does not have built in compression, what other
options are available? Are there any 3rd party plug-ins that interface with
sql server and provide a compressed dump file as it is being initially
written?I've listed some such 3:rd party apps at : http://www.karaszi.com/SQLServer/links.
asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JohnR" <JohnR@.discussions.microsoft.com> wrote in message
news:556E82D2-EA42-462F-BFDB-BA9A152AE2B0@.microsoft.com...
> Most if not all of the sql servers that I support are not on a SAN, and ar
e
> suffering from not having enough local space. This could be mitigated if
we
> were using some form of database dump compression. The optimum solution
> would be one which compresses the data as it was being initially written t
o
> the dump file.
> ( versus creating a full blown dump file and then running a second step to
> compress it )
> This compressed file would also benefit us in any subsequent copy steps,
> whereby we would be copying the file to another server for stand-by purpos
es.
> ( less network time/traffic )
> If Microsoft Sql server does not have built in compression, what other
> options are available? Are there any 3rd party plug-ins that interface wi
th
> sql server and provide a compressed dump file as it is being initially
> written?

No comments:

Post a Comment