TAILIEUCHUNG - Microsoft SQL Server 2008 R2 Unleashed- P42

Microsoft SQL Server 2008 R2 Unleashed- P42:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 354 CHAPTER 12 Data Encryption FIGURE Modifying TDE properties in SSMS. FIGURE Viewing TDE properties in SSMS. Backing up the certificate private key and master key for the server is relatively straightforward. An example of backing up the master key is shown in the following SQL statement BACKUP MASTER KEY TO FILE lc mssql2008 backup masterkeyl ENCRYPTION BY PASSWORD somekeybackuppassword Download from Transparent Data Encryption 355 Backing up the certificate and associated private key also uses the BACKUP command. The following example backs up the certificate created in Listing BACKUP CERTIFICATE MyCertificate TO FILE lc mssql2008 backup MyCertificatel WITH PRIVATE KEY FILE c mssql2008 backup MyCertificatePrivateKey ENCRYPTION BY PASSWORD somecertbackuppassword If you want to restore a database backup on another server instance a master key for the server must exist. If one does not exist you can create one by using the CREATE MASTER KEY ENCRYPTION syntax. After creating the master key you are able to create the TDE certificate from a backup of the certificate from the original SQL Server instance as shown in the following example CREATE CERTIFICATE MyCertificate FROM FILE ic mssql2008 backup MyCertificatei WITH PRIVATE KEY FILE c mssql2008 backup MyCertificatePrivateKey DECRYPTION BY PASSWORD somecertbackuppassword After the certificate is restored on the other server instance you can restore the encrypted database backup. At this point the restore can be performed just as you would restore any unencrypted database backup. The restored database is also encrypted and behaves like the original TDE database. TDE is a relatively simple and effective way to encrypt and protect your data. Other encryption methods that exist with SQL Server can protect different elements of your database. Encryption can be applied to columns of data an entire table as well as the communication that occurs between databases and the clients that access .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.