June 19, 2015 at 1:32 pm
Hello Experts
I wrote a custom procedure to shrink the db log files alone. It works well always but yesterday in one of the server the job execution was failed.
Error msg:
: The log for database 'ReportServer$DB' failed to grow while shrink in progress. Please retry. [SQLSTATE 42000] (Error 50000) Error 9020, Severity 16, State 2,
Do you smell any sign of issue here?
The code is v simple. It just shrinks the db log files of all user dbs.
I also checked and confirm you that against all dbs the auto-shrink feature is disabled.
If you have any suggestion on this, please do post to me.
Thanks.
June 19, 2015 at 2:32 pm
SQL-DBA-01 (6/19/2015)
Hello ExpertsI wrote a custom procedure to shrink the db log files alone. It works well always but yesterday in one of the server the job execution was failed.
Error msg:
: The log for database 'ReportServer$DB' failed to grow while shrink in progress. Please retry. [SQLSTATE 42000] (Error 50000) Error 9020, Severity 16, State 2,
Do you smell any sign of issue here?
The code is v simple. It just shrinks the db log files of all user dbs.
I also checked and confirm you that against all dbs the auto-shrink feature is disabled.
If you have any suggestion on this, please do post to me.
Well, basically the error is saying that the log failed to grow while a shrink was in progress.
So, it means exactly what it says: Something was going on that required the log to grow; but it cannot grow while it's in the process of shrinking. You also cannot shrink the log during a backup (database or transaction log).
The bigger question is: Why are you shrinking your logs in the first place?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply