Re: Encription for MDF files

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/28/05 

Date: Thu, 28 Jul 2005 07:51:21 -0400

I don't believe SQL Server supports encrypted files. If you don't want
someone to get ahold of your files then set the security on the box so that
only the people who need access have it. As for backups you should look at
SQL LiteSpeed from www.imceda.com . It allows you to encrypt the backup on
the fly. 

-- 
Andrew J. Kelly  SQL MVP
"Sharad2005" <niitmalad@yahoo.co.uk> wrote in message 
news:9667DEDF-C6BD-4817-BC5E-88941ABE10D2@microsoft.com...
> Dear Friends
>
> I want to use the encryption for the MDF files so that no one can just 
> copy
> the data and attach the MDF files to access the database.
>
> When i have done the same the database is in Suspect Mode. Please suggest
> what can be the reason.
>
> I also have the following questions.
>
> 1. Can another user restore the database backup for the encrypted MDF 
> files.
>
> Thanks in advance.
>
> Best regards
> Shailesh

Relevant Pages

  • Re: Securing fields
    ... definitely encrypt it. ... I'm planning on storing credit card numbers in my SQL database for online ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: local admin account password
    ... > encrypt the database and create alerts in the event of unsuccessful ... >> no more recovery console and don't think cached logins will work. ... >> The DB file would be encrypted with EFS so only the limited user SQL ... >> itself doesn't really need to be secure as the authentication is based ...
    (Focus-Microsoft)
  • Re: SQL Server 2000 / 2005 Encryption
    ... You require 3rd-party tools even when using the native SQL 2005 encryption ... to encrypt your SSL connections will be different. ... But you mentioned Excel cannot decrypt this information. ... Requests to the web services would connect to the database and invoke ...
    (microsoft.public.sqlserver.security)
  • RE: Encrypt data - SQL Server 2000
    ... > I suppose I've missed the intent of encryption within a SQL db. ... > would you want to encrypt data inside a database?. ... Does the server admin necessarily need to ...
    (Focus-Microsoft)
  • Re: SQL Server 2000 / 2005 Encryption
    ... encrypting the connection makes sense to me. ... This is possible on SQL 2005 via built-in T-SQL statements and functions, but requires 3rd-party tools, usually some sort of extended procedures. ... to encrypt your SSL connections will be different. ... Excel does not know how to decrypt data stored in SQL Server 2005 in encrypted form. ...
    (microsoft.public.sqlserver.security)