MS SQL Server - Maintenance Wizard

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Maintenance Wizard

2006-10-24, 6:33 pm

Hi

After running maintenance wizard, I getting a backup file that is the same
size like the DB but with .bak.

Is there a way to compress this file automaticly?

The original size is 11GB after compress the size is 700MB.

Any idea?

Than'x
Shay

John Bell

2006-10-24, 6:33 pm

Hi

You could compress the OS directory to save space, or if you wish to move
the backup elsewhere winrar has command line capabilities, so you could call
that as an extra step within the job. Products such as SQL Litespeed will
also do this for you http://www.quest.com/ litespeed_for_sql_se
rver/

John

"S" wrote:

> Hi
>
> After running maintenance wizard, I getting a backup file that is the same
> size like the DB but with .bak.
>
> Is there a way to compress this file automaticly?
>
> The original size is 11GB after compress the size is 700MB.
>
> Any idea?
>
> Than'x
> Shay
>
>
>

Sponsored Links