Why do people insist on using xpcmdshell when every best practices document (including the xpcmdshell topic in Books Online) recommends against its use?
What is the point of compressing a backup if the backup itself is already compressed?
What about encryption?
I would think a more secure solution would be to write a SQLCLR function that handles the compression (if necessary), encryption and transport.
commented on May 2 2012 10:21AM