October 28, 2009 at 3:20 am
Hi,
I've got a database back up that writes to the local server about 10 x 37gig files, the ten files then get moved to the main back up storage server into a folder that has the 'Compress contents to save disc space' ticked in the folder options. However over the past few days i've been getting a warning in the event view of the storage server that indicates that the second file of the back up is getting a 'Windows - Delayed Write Failed' as its been unable to save the data.
I did think that windows folder compression got a bit flaky over the 20gig, but i've got other database in other folders on the same SAN drive that are a back up of 40gig, and they compress fine?
My main question is, Is storing the backups in a compressed folder best practice?? and has anyone else seen this??
I may have to dump the idea of compression, and just leave the files uncompressed on the drive??
thanks
Jon
October 28, 2009 at 7:41 pm
I'm not sure about the file system compression. Before we purchased HyperBac, I was compressing the backup files using PKZip to reduce the amount of disk space used by the backup files and I had no issues with that when I had to uncompress files for a restore.
You may want to consider something like that instead of using the file system compression.
October 28, 2009 at 8:39 pm
I am going to repeat what Lynn stated - and recommend that you look into compressing the backup file instead of moving to a compressed folder.
The problem you are running into is that you are still copying the full contents across the wire - then those contents are being compressed at the destination. Using Hyperbac, or PKZIP, or some other method of compressing the backups will compress the files then send them across the wire.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply