SQL Server recovery model requirement

In order for report services to function efficiently, it’s recommended that you configure your SQL Server database to use the Simple recovery model. The recovery model configuration determines how SQL Server logs transactions, whether a database backs up the transaction log, and what kinds of restore options are available.

For more information about recovery models, please visit https://msdn.microsoft.com/en-us/library/ms189275.aspx.

To configure the SQL Server database recovery model:

  1. In SQL Server Management Studio, navigate to the database that you use for report services.
  2. Right-click the database and select Properties.
  3. In the Select a Page area, click Options.
  4. For the Recovery Model option, select Simple.
  5. Click OK to save the changes.