Monday, March 26, 2012

How to encrypt MS SQL Server 2000

How could i encrypt a ms sql 2000 database. what is when i do a backup of
the db. will i recieve a certificade with the key.
Does somebody have some experiences about the best way for encrypting an sql
server and the protocol.
Thank's for some infos
MichelMichel wrote:
> How could i encrypt a ms sql 2000 database. what is when i do a backup of
> the db. will i recieve a certificade with the key.
> Does somebody have some experiences about the best way for encrypting an sql
> server and the protocol.
> Thank's for some infos
> Michel
For encrypted backups: http://www.quest.com/litespeed_for_sql_server
Search Books Online for "encryption" to understand how to encrypt the
network protocol.
Encrypting the entire database rarely makes sense. If you need to store
or transmit the database via an insecure medium then use an encrypted
backup.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

No comments:

Post a Comment