millionboy
IS-IT--Management
I've encrypt a database with another's person profile.
Can you provide help to remove this encryption?
Many thanks
MnJ...
Can you provide help to remove this encryption?
Many thanks
MnJ...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to remove encryption on archive database?
- Thread starter millionboy
- Start date
- Status
The standard procedure in this case is to create a local replica copy, set the db encryption to nothing, then use an agent to Refresh all the documents therein.
The Refresh is not a simple F9 - view refresh, it is a full-blown @command([ToolsRefreshAllDocs]) agent that is run from the All Documents view and which will take time in proportion to the number and size of the documents it is to work on.
Once that is done, all encryption should be removed from the local replica. You can then replace the server copy with that one (with the Administrators help, of course).
Pascal.
The Refresh is not a simple F9 - view refresh, it is a full-blown @command([ToolsRefreshAllDocs]) agent that is run from the All Documents view and which will take time in proportion to the number and size of the documents it is to work on.
Once that is done, all encryption should be removed from the local replica. You can then replace the server copy with that one (with the Administrators help, of course).
Pascal.
- Status