Re: Using EFS - is there a better way?

From: Ben Nevarez (bnevarez_at_sjm.com)
Date: 11/16/05 

Date: Tue, 15 Nov 2005 23:21:23 -0800

Mmmm, 2005 BOL says 'The PASSWORD and MEDIAPASSWORD options will be removed
in a future release.'

Ben Nevarez

"Ben Nevarez" <bnevarez@sjm.com> wrote in message
news:%23jLIqvn6FHA.4076@tk2msftngp13.phx.gbl...
>
> Maybe you can use the password option for backup T-SQL command. This
> should work for both on disk and tape files.
>
> Ben Nevarez
>
>
>
> "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
> news:eecNsKj6FHA.1184@TK2MSFTNGP12.phx.gbl...
>> Hi
>>
>> The encryption is only whilst it is on disk. If you copy it to tape, the
>> encryption does not follow it.
>>
>> What are you worried about that you need to encrypt your data?
>>
>> Regards
>> --------------------------------
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>>
>> IM: mike@epprecht.net
>>
>> MVP Program: http://www.microsoft.com/mvp
>>
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Eric" <Eric@discussions.microsoft.com> wrote in message
>> news:609BCDE6-1ECB-4A79-8DA0-0DA2E970B5CC@microsoft.com...
>>>I want to encrypt my bak/trn backup files. Should I just use EFS? Can
>>> anyone recommend a better way to do this w/perhaps a third party tool?
>>>
>>> What about encrypting the mdf/ldf files? I know that performance will
>>> take
>>> a hit
>>> but wanted some input.
>>
>>
>
>