Backing up on windows compressed drive

Colleagues,
Does anybody have experience with backing up of MS SQL database on MS
Windows compressed drive? As for me, it is a good possibility to resolve disk
space problems and save some money. I know, that option of compressed backup
will be build in MS SQL 2008 and some 3-rd party products has the
functionality. But what about simple MS SQL backup on Windows compressed
drive?I asked this question a while ago and basically got blasted :)
- Don't let your hardware determin your business requirments.
- You won't actually know how much space is left and might fill the drive.
- backups and restores will table longer - mainly an issue with restores.
And I only was thinking about it for a dev system.
Still, depending on the compisition of your database, you could save a lot.
"Dmitrij Siemieniako" <Dmitrij Siemieniako@.discussions.microsoft.com> wrote
in message news:B0303671-D53F-49F7-8F01-ABD501AF8F17@.microsoft.com...
> Colleagues,
> Does anybody have experience with backing up of MS SQL database on MS
> Windows compressed drive? As for me, it is a good possibility to resolve
> disk
> space problems and save some money. I know, that option of compressed
> backup
> will be build in MS SQL 2008 and some 3-rd party products has the
> functionality. But what about simple MS SQL backup on Windows compressed
> drive?
>|||"Jay" <spam@.nospam.org> wrote in message
news:uTFvrDt9HHA.4880@.TK2MSFTNGP03.phx.gbl...
>I asked this question a while ago and basically got blasted :)
> - Don't let your hardware determin your business requirments.
> - You won't actually know how much space is left and might fill the drive.
> - backups and restores will table longer - mainly an issue with restores.
Depends on what he's suggesting. It's not 100% clear to me.
If he means to run the DB on a compressed drive, then no, that's a bad idea.
If he means backups TO a compressed drive, that's less risky.
And depending on many factors, backups/restores may in fact be faster, much
faster.
He can also look into some of the 3rd party backup solutions that compress
as they backup.
Very handy, especially for larger databases.
> And I only was thinking about it for a dev system.
> Still, depending on the compisition of your database, you could save a
> lot.
> "Dmitrij Siemieniako" <Dmitrij Siemieniako@.discussions.microsoft.com>
> wrote in message
> news:B0303671-D53F-49F7-8F01-ABD501AF8F17@.microsoft.com...
>> Colleagues,
>> Does anybody have experience with backing up of MS SQL database on MS
>> Windows compressed drive? As for me, it is a good possibility to resolve
>> disk
>> space problems and save some money. I know, that option of compressed
>> backup
>> will be build in MS SQL 2008 and some 3-rd party products has the
>> functionality. But what about simple MS SQL backup on Windows compressed
>> drive?
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Well, he did say "backing up"
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:e7tzrYu9HHA.1484@.TK2MSFTNGP06.phx.gbl...
> "Jay" <spam@.nospam.org> wrote in message
> news:uTFvrDt9HHA.4880@.TK2MSFTNGP03.phx.gbl...
>>I asked this question a while ago and basically got blasted :)
>> - Don't let your hardware determin your business requirments.
>> - You won't actually know how much space is left and might fill the
>> drive.
>> - backups and restores will table longer - mainly an issue with restores.
> Depends on what he's suggesting. It's not 100% clear to me.
> If he means to run the DB on a compressed drive, then no, that's a bad
> idea.
> If he means backups TO a compressed drive, that's less risky.
> And depending on many factors, backups/restores may in fact be faster,
> much faster.
> He can also look into some of the 3rd party backup solutions that compress
> as they backup.
> Very handy, especially for larger databases.
>
>> And I only was thinking about it for a dev system.
>> Still, depending on the compisition of your database, you could save a
>> lot.
>> "Dmitrij Siemieniako" <Dmitrij Siemieniako@.discussions.microsoft.com>
>> wrote in message
>> news:B0303671-D53F-49F7-8F01-ABD501AF8F17@.microsoft.com...
>> Colleagues,
>> Does anybody have experience with backing up of MS SQL database on MS
>> Windows compressed drive? As for me, it is a good possibility to resolve
>> disk
>> space problems and save some money. I know, that option of compressed
>> backup
>> will be build in MS SQL 2008 and some 3-rd party products has the
>> functionality. But what about simple MS SQL backup on Windows compressed
>> drive?
>>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>|||Thanks a lot, Jay. So, I'll try to move my backups on compressed drive.
Regards.
Dmitruj