SSISDB Transaction Log Backup

Posted on

Question :

I have several SSIS packages jobs running, and some months ago my disk got full because the size of the SSISDB database.

I noticed that the cleanup_server_retention_window was set to 365 days, and I changed it to one day. (It is a development server, and at this point I really dont care about the history).

The (big) problem, obviously, is now that the transaction log grows a lot and fast.

To prevent this, I start performing a full backup every week and a transaction log backup every day, and the size of the database is now controlled.

However, some more experienced guys are telling me that this is not the best aproach to this issue, but I cant see any problem with it..

I would like to know if there is a better solution for this.

Answer :

Change the recovery model to SIMPLE and be done with it since this is a Development server and you mentioned you don’t care about the history.

For more information on recovery models and transaction logs, see this excellent post from Gail Shaw.

Leave a Reply

Your email address will not be published. Required fields are marked *