Friday, March 23, 2012

ReportServerTempDB cannot unexpected log file growth

Hi,
ReportServerTempDB db log file cannot be shrunk. I'm not sure how, but in
sys.databases, the log_reuse_wait_desc field contains REPLICATION for both
the ReportServer and ReportServerTempDB records. I believe this should read
Nothing. I believe this may be our problem. Has anyone seen this or have any
suggestions.
Thanks!I ended up finding a workaround. Re-enabled the database for replication,
added a publication, then drop the publication, and remove replication.
Still don't know what may have caused this to happen.
"clutch" wrote:
> Hi,
> ReportServerTempDB db log file cannot be shrunk. I'm not sure how, but in
> sys.databases, the log_reuse_wait_desc field contains REPLICATION for both
> the ReportServer and ReportServerTempDB records. I believe this should read
> Nothing. I believe this may be our problem. Has anyone seen this or have any
> suggestions.
> Thanks!

No comments:

Post a Comment