Showing posts with label shrunk. Show all posts
Showing posts with label shrunk. Show all posts

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!