MS SQL server databse - set Recovery Mode to simple
search cancel

MS SQL server databse - set Recovery Mode to simple

book

Article ID: 226448

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

Can I do this?  It is just the MS SQL database for the jobs that are in my TEST/DEV AutoSys environment. 

I was just told to ask about this, as it is using a whole lot of disk space, and I want to switch the "Recovery Mode" to simple.

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

AutoSys can/will function regardless of what your database's "Recovery Mode" is set to.  It would be up to you and your dba to work out adjusting that database setting and testing it and understanding what the implications/steps would be should you need to restore/recovery the database.