cancel
Showing results for 
Search instead for 
Did you mean: 

SAP and Database Encrption on SQL Server 2005 or 2008

former_member397740
Discoverer
0 Kudos

Hi. I searched as best I could for any existing threads on this topic, and could not find any, so I hope it's OK to raise a new one.

We're running SAP ECC 6.0 on a SQL 2005 database. Database size is around 3.3 TB, with Trans Log of about 550GB, storage is HP EVA.

I've been asked to report on how Database Encryption would impact our systems, both from the perspective of enabling it initially and then how it would affect performance going forward.

I've read a few White Papers, for example:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/4ab89e84-0d01-0010-cda2-82ddc3548...

.. and from what I'm reading, it looks like I would want to be moving to SQL Server 2008 as a first step. Does anyone have any experience of implementing SQL encryption for a SAP database, either in 2K5 or 2K8?

All comments or help will be welcomed.

Thanks

Steven Clark

Accepted Solutions (0)

Answers (3)

Answers (3)

clas_hortien
Active Contributor
0 Kudos

Hi,

the note [1380493 - Transparent Data Encryption (TDE) unter SQL Server|http://service.sap.com/sap/support/notes/1380493]

has the details.

Regards

Clas

former_member397740
Discoverer
0 Kudos

Hi Eduardo

Thank you for your reply.

The links you supplied seem to all relate specifically to data compression, and not to database encryption, which is what I'm mostly interested in.

Thank you for trying to help, anyway.

Regards

Steven

former_member184473
Active Contributor
0 Kudos

Hello Steven,

You can also check the following websites:

http://blogs.msdn.com/b/saponsqlserver/archive/2011/09/05/decreased-disk-space-requirement-for-sap-u...

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/50c5de8f-282a-2e10-cb8a-a5859a0994a4&override...

And, SAP notes:

[1581700 PAGE compression support for DDIC & Hom./Het. System Copy|http://service.sap.com/sap/support/notes/1581700]

[1488135 Database compression for SQL Server|http://service.sap.com/sap/support/notes/1488135]

Regards,

Eduardo Rezende