I have a reporting services 2008 database and some reports. When I run the reports in the report manager I get the following error message:
An error occurred during client rendering.
An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.
The transaction log for database 'ReportServer' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
I have tried all kinds of things to shrink the log, to no avail.
I tried swapping the database over to simple, then doing a manual shrink file, but it says:
Cannot shrink file '2' in database 'ReportServer2k8' to 128 pages as it only contains 72 pages.
I have set the database back to full, and taken a manual backup. But log_reuse_wait remains as Nothing, and thereby I think it's prventing the log to be truncated.