Confluence DB from Full to Simple

Kimberly McCarty

Hello,

Can we change the Confluence DB from the Recovery Model being Full to Simple? We have been working on paring down the space being used by Confluence on the existing server and the log file on the there is about 97 GB while the DB is only 1.1 GB.

The DB is really only 2 GB in size and the log should be no bigger than that. Right now its grown to almost 100 GB.

Thank you,

Kimberly McCarty

Brant Schroeder

@Kimberly McCarty 

In my experience with MS SQL, this can tend to happen pretty easily when you have the recovery model for the database set to use FULL.  Microsoft has a number of documents that explain exactly how to do that: View or Change the Recovery Model of a Database (SQL Server)