You can decrypt a database using the CREATE DECRYPTED DATABASE statement. This statement creates a copy of the file (in decrypted form) and does not overwrite the original database file.
By default, you must have the SERVER OPERATOR system privilege to execute the CREATE DECRYPTED TABLE DATABASE statement. The required privileges can be changed by using the -gu database server option.
The database you are encrypting must not be running.
Context and remarks
If you have a database that requires recovery and you want to decrypt it to send it to Technical Support, you must use the CREATE DECRYPTED FILE statement. Any database-related files such as transaction logs and transaction log mirrors, and dbspace files, must also be decrypted using this statement.
In Interactive SQL, connect to a database other than the one you want to decrypt.
Execute a CREATE DECRYPTED DATABASE statement.
The first statement creates an AES256-encrypted copy of the temp.db database called encryptedtemp.db. The second statement creates a decrypted copy of encryptedtemp.db called decryptedtemp.db.
CREATE ENCRYPTED DATABASE 'C:\temp\encryptedtemp.db' FROM 'C:\temp\temp.db' KEY 'abc' ALGORITHM 'AES256'; CREATE DECRYPTED DATABASE 'C:\temp\decryptedtemp.db' FROM 'C:\temp\encryptedtemp.db' KEY 'abc';
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|