database encryption

Hello!
i am aware of the ability to encrypt something or issue a certificate for a
column, etc.
does the sql server itself write to disk in clear text?
if so, is there a feature to prevent that?
can a db not be mountable to another sql server without a password?
thank you very much for your help!
-Bahman"Bahman" <Bahman@.discussions.microsoft.com> wrote in message
news:4C85593A-F3A3-467B-AD51-32A87A99143C@.microsoft.com...
> Hello!
> i am aware of the ability to encrypt something or issue a certificate for
> a
> column, etc.
> does the sql server itself write to disk in clear text?
SQL Server stores data in binary format. Their might be some plain text
that can be seen if someone were to dissect your MDF files.

> if so, is there a feature to prevent that?
There are third party software encryption tools that encrypt the actual MDF
files, or even entire hard drives.|||"Bahman" <Bahman@.discussions.microsoft.com> wrote in message
news:4C85593A-F3A3-467B-AD51-32A87A99143C@.microsoft.com...
> Hello!
> i am aware of the ability to encrypt something or issue a certificate for
> a
> column, etc.
> does the sql server itself write to disk in clear text?
SQL Server stores data in binary format. Their might be some plain text
that can be seen if someone were to dissect your MDF files.

> if so, is there a feature to prevent that?
There are third party software encryption tools that encrypt the actual MDF
files, or even entire hard drives.|||In SQL Server 2005 the private key associated with a certificate is always
stored encrypted. See the famous Encryption Hierarchy chart at
http://msdn2.microsoft.com/en-US/library/ms189586.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"Bahman" <Bahman@.discussions.microsoft.com> wrote in message
news:4C85593A-F3A3-467B-AD51-32A87A99143C@.microsoft.com...
> Hello!
> i am aware of the ability to encrypt something or issue a certificate for
> a
> column, etc.
> does the sql server itself write to disk in clear text?
> if so, is there a feature to prevent that?
> can a db not be mountable to another sql server without a password?
> thank you very much for your help!
> -Bahman
>|||In SQL Server 2005 the private key associated with a certificate is always
stored encrypted. See the famous Encryption Hierarchy chart at
http://msdn2.microsoft.com/en-US/library/ms189586.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"Bahman" <Bahman@.discussions.microsoft.com> wrote in message
news:4C85593A-F3A3-467B-AD51-32A87A99143C@.microsoft.com...
> Hello!
> i am aware of the ability to encrypt something or issue a certificate for
> a
> column, etc.
> does the sql server itself write to disk in clear text?
> if so, is there a feature to prevent that?
> can a db not be mountable to another sql server without a password?
> thank you very much for your help!
> -Bahman
>|||Can someone recommend a good highly scalable and easy to use 3rd party tool
to encrypt the contents of a disk. Keep in mind that I run a SQL Cluster. So
the disk is not local. It resides on the SAN.
TIA!
"Mike C#" <xxx@.yyy.com> wrote in message news:Na1lg.294$B95.11@.fe10.lga...
> "Bahman" <Bahman@.discussions.microsoft.com> wrote in message
> news:4C85593A-F3A3-467B-AD51-32A87A99143C@.microsoft.com...
> SQL Server stores data in binary format. Their might be some plain text
> that can be seen if someone were to dissect your MDF files.
>
> There are third party software encryption tools that encrypt the actual
> MDF files, or even entire hard drives.
>|||Can someone recommend a good highly scalable and easy to use 3rd party tool
to encrypt the contents of a disk. Keep in mind that I run a SQL Cluster. So
the disk is not local. It resides on the SAN.
TIA!
"Mike C#" <xxx@.yyy.com> wrote in message news:Na1lg.294$B95.11@.fe10.lga...
> "Bahman" <Bahman@.discussions.microsoft.com> wrote in message
> news:4C85593A-F3A3-467B-AD51-32A87A99143C@.microsoft.com...
> SQL Server stores data in binary format. Their might be some plain text
> that can be seen if someone were to dissect your MDF files.
>
> There are third party software encryption tools that encrypt the actual
> MDF files, or even entire hard drives.
>|||You can use encrypt data and file using SQL Server 2005.
In SQL Serer 2005 support many Encryption methods.
And can use EFS, NTFS .
"Bahman"?? ??? ??:

> Hello!
> i am aware of the ability to encrypt something or issue a certificate for
a
> column, etc.
> does the sql server itself write to disk in clear text?
> if so, is there a feature to prevent that?
> can a db not be mountable to another sql server without a password?
> thank you very much for your help!
> -Bahman
>|||You can use encrypt data and file using SQL Server 2005.
In SQL Serer 2005 support many Encryption methods.
And can use EFS, NTFS .
"Bahman"?? ??? ??:

> Hello!
> i am aware of the ability to encrypt something or issue a certificate for
a
> column, etc.
> does the sql server itself write to disk in clear text?
> if so, is there a feature to prevent that?
> can a db not be mountable to another sql server without a password?
> thank you very much for your help!
> -Bahman
>