DBA > Job Interview Questions > Microsoft SQL Server FAQs

You wish to back up the symmetric key used to pr

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

You wish to back up the symmetric key used to protect data on the Reporting Services 2005 instance installed on Sales01. From your workstation, what command do you use?

Answer: You cannot do this from your workstation.
Explanation: While you can extract and back up the key to a file with the rskeymgmt utility, you must do it from the server itself. The typical command is:
rskeymgmt -e -f a:\backupkey\keys -p <password>

(Continued on next question...)

Other Job Interview Questions