Re: Encrypt/Decrypt SQL Server 2005 data files


"Robert Robinson" <robbiex@xxxxxxxxxxxxx> wrote in message
news:uibht4IEHHA.3600@xxxxxxxxxxxxxxxxxxxxxxx
We decided on the following to provide a reasonable level of protection.
First, computer access is limited by using the SecuriKey.
SQL database files are protected as follows:
Setup
1. The SQL databases to be protected are backed up and are then deleted
from SQL Server.

Are you concerned that fragments of unencrypted data might be lying around
on the storage device even after deletion? Just curious. Thanks.


.

Relevant Pages

  • Re: Encrypt/Decrypt SQL Server 2005 data files
    ... We decided on the following to provide a reasonable level of protection. ... computer access is limited by using the SecuriKey. ... A new SQL database is created with its data and log files assigned to be resident on the virtual disk. ...
    (microsoft.public.sqlserver.security)
  • Re: defragging SQL Database files
    ... were you ever able to get the disk to defrag? ... > the SQL Database files? ...
    (microsoft.public.sqlserver.datamining)
  • SQL File Viewer
    ... Can anyone recommend a file fiewer for SQL database files? ... small extract of an SQL database that I want to look at without ... installing the entire database app. ...
    (microsoft.public.sqlserver.server)
  • File Viewer
    ... I have a small extract of an SQL database and I'd like to view it ... without having to install and configure SQL server. ... recommend a file viewer that can read SQL database files? ...
    (microsoft.public.sqlserver.setup)