xp_cmdshell encryption in SQL2005

Question

xp_cmdshell encryption in SQL2005

muthukrishnan.kumaresan

Valued Member

Points: 52
More actions
July 29, 2009 at 8:36 am

#207391

Hi,
I am using xp_cmdshell to copy the backup files(DB Backup and transaction log) from Production server to Backup Server over the network. I would like to know whether we have any way to encrypt the file transfer.
I am using SQL 2000 and SQL 2005 servers.
Thanks.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

Are you worried abou them in transit or at rest.

You could use some command line encryption routine and encrypt them then delete the clear-text file then copy the encrypted version.

Why don't you explain the problem you are trying to solve and how this fits in?

CEWII

muthukrishnan.kumaresan Valued Member Points: 52 More actions · Answer 2

I am worried over the network(transit)

Can you pls elaborate on the below statement.

You could use some command line encryption routine and encrypt them then delete the clear-text file then copy the encrypted version.

Thanks.

muthukrishnan.kumaresan Valued Member Points: 52 More actions · Answer 3

I am worried over the network(transit)

Can you pls elaborate on the below statement.

You could use some command line encryption routine and encrypt them then delete the clear-text file then copy the encrypted version.

Thanks.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 4

Unless you are in a banking/lending company the data does not likely need right protection. With that said, what are you really worried about, somebody with a network sniffer stealing your data, or are you copying the data over an external networks outside your organziation..

As far as elaborating..

There are command line executables (programs that can be called from command shell with parameters) that you could do the encryption with. And then delete the original file (cleartext version) and then move/copy the encrypted version.

Clear?

CEWII

muthukrishnan.kumaresan Valued Member Points: 52 More actions · Answer 5

Thanks for your reply.

Yes our is banking environment. We are transferring files in our network only.

Just I am looking for the possibility to encrypt the file transfer.

Can you give some idea about what is this command line executable? Is it third party tool/program? Can we integrate this tool with xp_cmdshell?

Thanks.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 6

The encryption stuff is all 3rd party, there are a number of vendors, PGP is probably the most common.. Do a search on google with this term: command line encryption

And look at the results..

Since you are using 2005 you may be able to get a SQLCLR object..

CEWII