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!
Friday, March 23, 2012
ReportServerTempDB cannot unexpected log file growth
Labels:
contains,
database,
databases,
field,
file,
growth,
log,
log_reuse_wait_desc,
microsoft,
mysql,
oracle,
replication,
reportservertempdb,
server,
shrunk,
sql,
sys,
unexpected
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment