Abstract. The security workflow is proposed according to the transactional workflow discussed in this paper. When it comes to the security workflow, it is necessary to consider the compensation of the attack. In this paper, the recovery properties is introduced in security database workflow: non-vital property, compensable property, retriable property, critical property and replaceable property. With these properties discussed, the paper deeply analyses the abnormal workflow and advises the division of the abnormality. Further, some recovery modes for transaction workflow and security workflow are proposed. Finally, the paper presents the recovery algorithm for database storage. In that algorithm, the paper considers the difference between the master and the slave. The process method of the master database and the slave database is also discussed.