 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Other SQL Server Topics / August 2007how to proceed
Dear Experts. I have a SQL Server 2000 on my production machine and contains 31 databases, one of the database contain most critical information, now our organization wants that database should be encrypted, just because of that I am going to installed SQL Server 2005 side by side installation on the same box and restore that database into SQL Server 2005 and implement the encryption, I would appreciate if any one of your guide me the better approach or what sort of information I have to be considered before installing and implementing this. Thanks in advance. Hello Rogers, Will you tell us what kind of an encryption did you use for your database?  SignatureEkrem Önsoy > Dear Experts. > [quoted text clipped - 8 lines] > > Thanks in advance. That's also I want to ask from you guys like I have a Windows 2003 Server Service Pack 2. Which Encryption would be best and more secure. I would appreciate if you can send me any step by step Installation & Encryption website. Thanks > Hello Rogers, > [quoted text clipped - 12 lines] >> >> Thanks in advance. Well... It depends on your needs. If you are looking for a tough encryption (this brings performance degradation), then you could use Certificates \ Asymmetric Keys, If you are looking for an encryption (which is not as powerful as the previous ones) which does not affect performance as much as the others, then you could Symmetric Keys. It's your choice. But both of them asks for a sacrifice from your system. Please read the following articles from BOL About Master Key: http://msdn2.microsoft.com/en-us/library/ms174382.aspx Symmetric Key: http://msdn2.microsoft.com/en-us/library/ms188357.aspx Asymmetric Key: http://msdn2.microsoft.com/en-us/library/ms174430.aspx Certificate: http://msdn2.microsoft.com/en-us/library/ms187798.aspx SignatureEkrem Önsoy > That's also I want to ask from you guys like I have a Windows 2003 Server > Service Pack 2. Which Encryption would be best and more secure. I would [quoted text clipped - 20 lines] >>> >>> Thanks in advance. I think I have to go to Symmetric Key becuase I also want good performance, Sql Server 2000 already installed into that Server and I am going to install SQL Server 2005 as a Named Instace. Here is my server configuration, What is your thought. Windows Server 2003 Service Pack 2 Dell Server 2.99 GHz 2 GB of RAM Thanks > Well... It depends on your needs. > [quoted text clipped - 44 lines] >>>> >>>> Thanks in advance. Well, I do not know the possible workload on your server so I don't have any clue about how it is going to work. I suggest you to install R2 to your Windows Server 2003 if you have not. Good luck! SignatureEkrem Önsoy >I think I have to go to Symmetric Key becuase I also want good >performance, Sql Server 2000 already installed into that Server and I am [quoted text clipped - 57 lines] >>>>> >>>>> Thanks in advance. R2 means Raid? Thanks > Well, I do not know the possible workload on your server so I don't have > any clue about how it is going to work. [quoted text clipped - 65 lines] >>>>>> >>>>>> Thanks in advance. Check it out http://www.microsoft.com/windowsserver2003/default.mspx SignatureEkrem Önsoy > R2 means Raid? > [quoted text clipped - 69 lines] >>>>>>> >>>>>>> Thanks in advance. Thanks.. > Check it out > [quoted text clipped - 74 lines] >>>>>>>> >>>>>>>> Thanks in advance. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.