Encription for MDF files

From: Sharad2005 (niitmalad_at_yahoo.co.uk)
Date: 07/28/05 

Date: Thu, 28 Jul 2005 01:29:04 -0700

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: How to retrieve database password
    ... All I have are the old .SQL files no MDF files were created. ... > If you have the MDF files, just attach the database to a new instance ... > If you mean a specially created user in the database or server AFAIK ... > stored password in the source code) ...
    (microsoft.public.sqlserver.msde)
  • RE: Encription for MDF files
    ... Did you encrypt the file/directory when logged in as the SQL Server Service ... one account. ... the encryption certificate becomes invalid and you loose total ... > the data and attach the MDF files to access the database. ...
    (microsoft.public.sqlserver.security)
  • strange setup for a datawarehouse server?
    ... would ever restore a database would be to get an object back, ... how many LDF and MDF files should our databasehave? ... set up with 4 MDF files and 4 LDF files. ... I've read BO's backing up the transaction log and ...
    (microsoft.public.sqlserver.setup)
  • Re: Creating SQL Server Databases With No Security Restrictions
    ... > this question involved both MSDE and security settings. ... We are able to copy the .mdf files to the ... > to create a database link to the file (Connect To Database button on ... > appears in the list of databases under the SQL Server instance and is ...
    (microsoft.public.sqlserver.msde)
  • Re: Creating SQL Server Databases With No Security Restrictions
    ... > this question involved both MSDE and security settings. ... We are able to copy the .mdf files to the ... > to create a database link to the file (Connect To Database button on ... > appears in the list of databases under the SQL Server instance and is ...
    (microsoft.public.sqlserver.security)