pmadhavapeddi22 (1/30/2014)
I too agree with patrick, When we are compressing already compressed db we wont get much space in it. That is why i feel option C is correctthanks
Precisely. If one database is 50GB native and the other 50GB compressed, then you're going to get more compression when backing up the first database than when backing up the second. Hence the first backup will be smaller. There are ciircumstances in which C would be the correct answer - for example if your uncompressed backup contained mainly uncompressible LOB data - JPEG files, maybe. In that case, you wouldn't get much compression when backing it up.
John