April 29, 2003 at 7:45 am
Making backups to compressed disk to save disk space, can give troubles?
Thank you,
Martin.
April 29, 2003 at 9:11 am
I do it all the time, saves about 50 % dasd.
Never seen a problem, although I have heard of problems taking a .Bak, zipping it, transfering it, then restoring it.
KlK, MCSE
KlK
April 29, 2003 at 9:19 am
Now there is a acronym "DASD" that I normally don't here people use any more. I do all the time, and people look at me like they don't know what I'm talkig about. Seems like the term "Disk Space" is more well known these days.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
April 29, 2003 at 10:26 am
Im using compression on one server that is short on space, works well. Haven't done a comparision yet to see the time difference - don't have enough space to try it uncompressed! Perhaps on another server one of these days...
Andy
April 29, 2003 at 8:03 pm
Are we talking NT4 and early drive compression or the newer found in 2000 and later. I remember there being an article on MSDN about a change to this and that compressions over X number of GBs was the issue with NT4 but that was corrected to an increased size in 2000. The compression is lossless up to that point thou.
April 30, 2003 at 3:57 am
Found it, check out http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/base/file_compression_and_decompression.asp if the file is greater than 30GB it may not succeed in compression. And it goes into the compression format used.
April 30, 2003 at 6:33 am
I dont see the limit referenced in that link?
Andy
April 30, 2003 at 6:40 am
About half way down it reads.
quote:
Note that compressing a file that is larger than 30 gigabytes may not succeed.
April 30, 2003 at 9:55 am
Thanks Greg, Make me feel old :-}
I've been in this Biz an real long time. I just stay with current technologies. My current job has very little MainFrame usage, mostly just to pull file down to load into SQL Server or UDB.
KlK, MCSE
KlK
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply