Re: Using EFS - is there a better way?
From: Ben Nevarez (bnevarez_at_sjm.com)
Date: 11/16/05
- Previous message: Jasper Smith: "Re: Permissions WTF"
- In reply to: Mike Epprecht \(SQL MVP\): "Re: Using EFS - is there a better way?"
- Next in thread: Ben Nevarez: "Re: Using EFS - is there a better way?"
- Reply: Ben Nevarez: "Re: Using EFS - is there a better way?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 15 Nov 2005 23:03:52 -0800
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.
>
>
- Previous message: Jasper Smith: "Re: Permissions WTF"
- In reply to: Mike Epprecht \(SQL MVP\): "Re: Using EFS - is there a better way?"
- Next in thread: Ben Nevarez: "Re: Using EFS - is there a better way?"
- Reply: Ben Nevarez: "Re: Using EFS - is there a better way?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|