Encryption ?

Does SQL Server use any type of encryption internally ?
eg. when I take backup of a database is it encrypted if yes then how many bit encryption does it use ?

When a client makes a connection to SQL 2000 server, does it use encryption ? if yes then how many bit encryption is it ?

Any help would be appreciated.

ThanksHi ,

sql server allows for encryption of data for both 16-bit and 32-bit clients with the encryption option of the Multi-Procotol Network Library.

to enable encryption you can select the "Enable multi-protocol encryption" checkbox in the sql server setup program.

hope this clarifies your doubt.

thanks

Encrypting datafile and backups

Hi
I read good article on EFS
http://www.sqlservercentral.com/colu...enting_efs.asp
How do you do encryption of backups
I found that the backup made from a encrypted data if recovered are not
encrypted as it is OS encrytion and not database.
Also another interesting question on same line:
If the domain account used to start the sqlserver and encryption is deleted
and recreated with the same login/password will that user be able to decrypt
the files.
Mangesh
Also if we can recover the encrypted file
Mangesh Deshpande wrote:
> Hi
> I read good article on EFS
> http://www.sqlservercentral.com/colu...enting_efs.asp
> How do you do encryption of backups
> I found that the backup made from a encrypted data if recovered are
> not encrypted as it is OS encrytion and not database.
> Also another interesting question on same line:
> If the domain account used to start the sqlserver and encryption is
> deleted and recreated with the same login/password will that user be
> able to decrypt the files.
> Mangesh
> Also if we can recover the encrypted file
You can use a tool like LiteSpeed to encrypt your backups (url below).
David Gugick
Imceda Software
www.imceda.com
|||Hi
EFS is based on Certificates. You loose the Certificate, you loose access to
your data. If you re-set a user's pasword, his certificates become invalid.
Regards
Mike
"Mangesh Deshpande" wrote:

> Hi
> I read good article on EFS
> http://www.sqlservercentral.com/colu...enting_efs.asp
> How do you do encryption of backups
> I found that the backup made from a encrypted data if recovered are not
> encrypted as it is OS encrytion and not database.
> Also another interesting question on same line:
> If the domain account used to start the sqlserver and encryption is deleted
> and recreated with the same login/password will that user be able to decrypt
> the files.
> Mangesh
> Also if we can recover the encrypted file
sql

Encrypting datafile and backups

Hi
I read good article on EFS
http://www.sqlservercentral.com/col...menting_efs.asp
How do you do encryption of backups
I found that the backup made from a encrypted data if recovered are not
encrypted as it is OS encrytion and not database.
Also another interesting question on same line:
If the domain account used to start the sqlserver and encryption is deleted
and recreated with the same login/password will that user be able to decrypt
the files.
Mangesh
Also if we can recover the encrypted fileMangesh Deshpande wrote:
> Hi
> I read good article on EFS
> http://www.sqlservercentral.com/col...menting_efs.asp
> How do you do encryption of backups
> I found that the backup made from a encrypted data if recovered are
> not encrypted as it is OS encrytion and not database.
> Also another interesting question on same line:
> If the domain account used to start the sqlserver and encryption is
> deleted and recreated with the same login/password will that user be
> able to decrypt the files.
> Mangesh
> Also if we can recover the encrypted file
You can use a tool like LiteSpeed to encrypt your backups (url below).
David Gugick
Imceda Software
www.imceda.com|||Hi
EFS is based on Certificates. You loose the Certificate, you loose access to
your data. If you re-set a user's pasword, his certificates become invalid.
Regards
Mike
"Mangesh Deshpande" wrote:

> Hi
> I read good article on EFS
> http://www.sqlservercentral.com/col...menting_efs.asp
> How do you do encryption of backups
> I found that the backup made from a encrypted data if recovered are not
> encrypted as it is OS encrytion and not database.
> Also another interesting question on same line:
> If the domain account used to start the sqlserver and encryption is delete
d
> and recreated with the same login/password will that user be able to decry
pt
> the files.
> Mangesh
> Also if we can recover the encrypted file

Encrypting Backups

Is there any way to encrypt a backup written to a tape drive?
I know its possible to do when backing up to disk (using an encrypted file
system), but don't see how to achieve the same with tape.
We want to take our backups off-site, and though it would be prudent to
encrypt the data in casae it was lost, stolen, etc.
Thanks,
LenYou might want to look at some 3rd party apps such as SQLLiteSpeed. They
can compress and encrypt the backups.
Andrew J. Kelly SQL MVP
"Len Binns" <binns@.buffalo.nospam.edu> wrote in message
news:OtDqtzEuEHA.1472@.TK2MSFTNGP10.phx.gbl...
> Is there any way to encrypt a backup written to a tape drive?
> I know its possible to do when backing up to disk (using an encrypted file
> system), but don't see how to achieve the same with tape.
> We want to take our backups off-site, and though it would be prudent to
> encrypt the data in casae it was lost, stolen, etc.
> Thanks,
> Len
>|||BTW,
We're using SQL 2000 on Windows Server 2003, Enterprise Edition.
"Len Binns" <binns@.buffalo.nospam.edu> wrote in message
news:OtDqtzEuEHA.1472@.TK2MSFTNGP10.phx.gbl...
> Is there any way to encrypt a backup written to a tape drive?
> I know its possible to do when backing up to disk (using an encrypted file
> system), but don't see how to achieve the same with tape.
> We want to take our backups off-site, and though it would be prudent to
> encrypt the data in casae it was lost, stolen, etc.
> Thanks,
> Len
>|||We were hoping to stay away from 3rd party apps (just one more thing to
break), but we may have to if there is no other solution.
Is there no solution native to SQL Server 2000 and/or Windows Server 2003?
Thanks,
Len
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%236wuA5EuEHA.4040@.tk2msftngp13.phx.gbl...
> You might want to look at some 3rd party apps such as SQLLiteSpeed. They
> can compress and encrypt the backups.
> --
> Andrew J. Kelly SQL MVP
>
> "Len Binns" <binns@.buffalo.nospam.edu> wrote in message
> news:OtDqtzEuEHA.1472@.TK2MSFTNGP10.phx.gbl...
file[vbcol=seagreen]
>|||There are no native solutions that I know of for SQL Server. SQL LiteSpeed
is pretty seamless and will enhance your backup and restore capabilities
tremendously. They will be faster, take up less room and uses RC4
encryption. I know it sounds like I am an Imceda salesman but this product
does what it claims and what you are asking for.
Andrew J. Kelly SQL MVP
"Len Binns" <binns@.buffalo.nospam.edu> wrote in message
news:%23oW4FPFuEHA.3320@.TK2MSFTNGP15.phx.gbl...
> We were hoping to stay away from 3rd party apps (just one more thing to
> break), but we may have to if there is no other solution.
> Is there no solution native to SQL Server 2000 and/or Windows Server 2003?
> Thanks,
> Len
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%236wuA5EuEHA.4040@.tk2msftngp13.phx.gbl...
> file
>

encrypting backup in sql2000

Hi
Does anyone know what is the best way to encrypt the backups in sql server
2000.
I know sqllite software but are there any freeware or utilities that
can encrypt the backups.
Tks
Mangesh
there could be others as well but the one I found out randomly is
Mizo - CD Librarian License: Freeware
You can find it:
http://www.dirfile.com/freeware/stor...-migration.htm
Regards,

encrypting backup in sql2000

Hi
Does anyone know what is the best way to encrypt the backups in sql server
2000.
I know sqllite software but are there any freeware or utilities that
can encrypt the backups.
Tks
Mangeshthere could be others as well but the one I found out randomly is
Mizo - CD Librarian License: Freeware
You can find it:
http://www.dirfile.com/freeware/sto...e-migration.htm
Regards,sql

encrypting backup in sql2000

Hi
Does anyone know what is the best way to encrypt the backups in sql server
2000.
I know sqllite software but are there any freeware or utilities that
can encrypt the backups.
Tks
Mangeshthere could be others as well but the one I found out randomly is
Mizo - CD Librarian License: Freeware
You can find it:
http://www.dirfile.com/freeware/stored-procedure-migration.htm
Regards,

Encrypted stored proc

We have a third party app that had some bad code run against it this morning
.
We are trying to restore an SP from our backup but it is encrypted. Does
anyone know of a way to restore\de-encrypt an encrypted proc?
TIA, Jordanhttp://www.planetsourcecode.com/vb/...6J00S003GU.html
David Portas
SQL Server MVP
--|||There are some thirdparty stored procedures/ Application to do this.
You can search and find then in the net.

Emptying Log file

Backup Log has Active and Inactive Portions. To Truncate Inactive
portion user the following command in SQL Query Analyser
USE The following Command
BACKUP LOG { database_name | @.database_name_var }
WITH TRUNCATE_ONLYThanx Rex
*** Sent via Developersdex http://www.examnotes.net ***

Empty log file

Hello
Someone said to me that only a complete tape backup will empty the log file. THe log is backed up but the file is not empty
I thought that a complete backup to disk or tape will empty the log file
Do anyone know the answer
Regard
Stefan NäsmanI'm not sure what you mean by "complete backup". A database backup does not
empty the log file, nor does a differential, file or filegroup backup. The
only backup type that actually empties a log file is a transaction log
backup. If you don't want to do transaction log backups (for some strange
reason), then just put the database in simple recovery mode.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Stefan Näsman" <anonymous@.discussions.microsoft.com> wrote in message
news:7F9F50EB-4463-48A8-9150-D6C2FCDFED1E@.microsoft.com...
> Hello!
> Someone said to me that only a complete tape backup will empty the log
file. THe log is backed up but the file is not empty.
> I thought that a complete backup to disk or tape will empty the log file.
> Do anyone know the answer?
> Regards
> Stefan Näsman|||Stefan
Backup Log file removes inactivate portion of log file ( commited
transaction written to the disk)
"Stefan N?sman" <anonymous@.discussions.microsoft.com> wrote in message
news:7F9F50EB-4463-48A8-9150-D6C2FCDFED1E@.microsoft.com...
> Hello!
> Someone said to me that only a complete tape backup will empty the log
file. THe log is backed up but the file is not empty.
> I thought that a complete backup to disk or tape will empty the log file.
> Do anyone know the answer?
> Regards
> Stefan N?sman

Empty log file

Hello!
Someone said to me that only a complete tape backup will empty the log file.
THe log is backed up but the file is not empty.
I thought that a complete backup to disk or tape will empty the log file.
Do anyone know the answer?
Regards
Stefan N?smanI'm not sure what you mean by "complete backup". A database backup does not
empty the log file, nor does a differential, file or filegroup backup. The
only backup type that actually empties a log file is a transaction log
backup. If you don't want to do transaction log backups (for some strange
reason), then just put the database in simple recovery mode.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Stefan Nsman" <anonymous@.discussions.microsoft.com> wrote in message
news:7F9F50EB-4463-48A8-9150-D6C2FCDFED1E@.microsoft.com...
> Hello!
> Someone said to me that only a complete tape backup will empty the log
file. THe log is backed up but the file is not empty.
> I thought that a complete backup to disk or tape will empty the log file.
> Do anyone know the answer?
> Regards
> Stefan Nsman|||Stefan
Backup Log file removes inactivate portion of log file ( commited
transaction written to the disk)
"Stefan N?sman" <anonymous@.discussions.microsoft.com> wrote in message
news:7F9F50EB-4463-48A8-9150-D6C2FCDFED1E@.microsoft.com...
> Hello!
> Someone said to me that only a complete tape backup will empty the log
file. THe log is backed up but the file is not empty.
> I thought that a complete backup to disk or tape will empty the log file.
> Do anyone know the answer?
> Regards
> Stefan N?sman

Empty a Database SQL 2000

Hello,
Is there a way to export a database and delete the contents of it as
it creates the backup - leaving the database intact but devoid of
data?
Thanks,
TmuldHi,
You could create SP which uses BACKUP and TRUNCATE TABLE statement, I
guess. Is it something you want, or is there another constraint?
Tmuldoon wrote:
> Hello,
> Is there a way to export a database and delete the contents of it as
> it creates the backup - leaving the database intact but devoid of
> data?
> Thanks,
> Tmuld
>|||See Dan's post some times ago
DECLARE @.TruncateStatement nvarchar(4000)
DECLARE TruncateStatements CURSOR LOCAL FAST_FORWARD
FOR
SELECT
N'TRUNCATE TABLE ' +
QUOTENAME(TABLE_SCHEMA) +
N'.' +
QUOTENAME(TABLE_NAME)
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_TYPE = 'BASE TABLE' AND
OBJECTPROPERTY(OBJECT_ID(QUOTENAME(TABLE_SCHEMA) +
N'.' +
QUOTENAME(TABLE_NAME)), 'IsMSShipped') = 0
OPEN TruncateStatements
WHILE 1 = 1
BEGIN
FETCH NEXT FROM TruncateStatements INTO @.TruncateStatement
IF @.@.FETCH_STATUS <> 0 BREAK
RAISERROR (@.TruncateStatement, 0, 1) WITH NOWAIT
EXEC(@.TruncateStatement)
END
CLOSE TruncateStatements
DEALLOCATE TruncateStatements
"Tmuldoon" <tmuldoon@.spliced.com> wrote in message
news:1185920307.362745.28610@.d30g2000prg.googlegroups.com...
> Hello,
> Is there a way to export a database and delete the contents of it as
> it creates the backup - leaving the database intact but devoid of
> data?
> Thanks,
> Tmuld
>

Empty a Database SQL 2000

Hello,
Is there a way to export a database and delete the contents of it as
it creates the backup - leaving the database intact but devoid of
data?
Thanks,
Tmuld
Hi,
You could create SP which uses BACKUP and TRUNCATE TABLE statement, I
guess. Is it something you want, or is there another constraint?
Tmuldoon wrote:
> Hello,
> Is there a way to export a database and delete the contents of it as
> it creates the backup - leaving the database intact but devoid of
> data?
> Thanks,
> Tmuld
>
|||See Dan's post some times ago
DECLARE @.TruncateStatement nvarchar(4000)
DECLARE TruncateStatements CURSOR LOCAL FAST_FORWARD
FOR
SELECT
N'TRUNCATE TABLE ' +
QUOTENAME(TABLE_SCHEMA) +
N'.' +
QUOTENAME(TABLE_NAME)
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_TYPE = 'BASE TABLE' AND
OBJECTPROPERTY(OBJECT_ID(QUOTENAME(TABLE_SCHEMA) +
N'.' +
QUOTENAME(TABLE_NAME)), 'IsMSShipped') = 0
OPEN TruncateStatements
WHILE 1 = 1
BEGIN
FETCH NEXT FROM TruncateStatements INTO @.TruncateStatement
IF @.@.FETCH_STATUS <> 0 BREAK
RAISERROR (@.TruncateStatement, 0, 1) WITH NOWAIT
EXEC(@.TruncateStatement)
END
CLOSE TruncateStatements
DEALLOCATE TruncateStatements
"Tmuldoon" <tmuldoon@.spliced.com> wrote in message
news:1185920307.362745.28610@.d30g2000prg.googlegro ups.com...
> Hello,
> Is there a way to export a database and delete the contents of it as
> it creates the backup - leaving the database intact but devoid of
> data?
> Thanks,
> Tmuld
>

Empty a Database SQL 2000

Hello,
Is there a way to export a database and delete the contents of it as
it creates the backup - leaving the database intact but devoid of
data?
Thanks,
TmuldHi,
You could create SP which uses BACKUP and TRUNCATE TABLE statement, I
guess. Is it something you want, or is there another constraint?
Tmuldoon wrote:
> Hello,
> Is there a way to export a database and delete the contents of it as
> it creates the backup - leaving the database intact but devoid of
> data?
> Thanks,
> Tmuld
>|||See Dan's post some times ago
DECLARE @.TruncateStatement nvarchar(4000)
DECLARE TruncateStatements CURSOR LOCAL FAST_FORWARD
FOR
SELECT
N'TRUNCATE TABLE ' +
QUOTENAME(TABLE_SCHEMA) +
N'.' +
QUOTENAME(TABLE_NAME)
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_TYPE = 'BASE TABLE' AND
OBJECTPROPERTY(OBJECT_ID(QUOTENAME(TABLE
_SCHEMA) +
N'.' +
QUOTENAME(TABLE_NAME)), 'IsMSShipped') = 0
OPEN TruncateStatements
WHILE 1 = 1
BEGIN
FETCH NEXT FROM TruncateStatements INTO @.TruncateStatement
IF @.@.FETCH_STATUS <> 0 BREAK
RAISERROR (@.TruncateStatement, 0, 1) WITH NOWAIT
EXEC(@.TruncateStatement)
END
CLOSE TruncateStatements
DEALLOCATE TruncateStatements
"Tmuldoon" <tmuldoon@.spliced.com> wrote in message
news:1185920307.362745.28610@.d30g2000prg.googlegroups.com...
> Hello,
> Is there a way to export a database and delete the contents of it as
> it creates the backup - leaving the database intact but devoid of
> data?
> Thanks,
> Tmuld
>