Here is the full error from the error log

"

Date 13/01/2023 11:45:04 AM

Log SQL Server Agent (Current - 13/01/2023 11:37:00 AM)

Message

[136] Job CheckDBIntegrity reported: The process could not be created for...

Grant , its a DBCC CheckDB that I am calling from an agent job. It runs well but has error message at the end saying it cannot see the output...

Grant , its a DBCC CheckDB that I am calling from an agent job. It runs well but has error message at the end saying it cannot see the output...

@ant-green, these are the answers:

Firstly do you know what caused the log file to grow that large?    - I inherited just a week ago , and no documentation or...

Hi Grant,

No , there is Log a shipping setup that backs up log every 1 Hr.thanks

Well, I guess the log files have not been actually growing fast given a nominal size-increase I noticed last few days.So , as you said, they might just be normal...

Well, I guess the log files have not been actually growing fast given a nominal size-increase I noticed last few days.So , as you said, they might just be normal...

Hi @Ant-green,

I actually acquired this newly. I am sure there was no analysis ever done. But yes , there is log shipping enabled and the Log backup setup within the...

Log contents only have 214 rows . Majority of the operations are for LOP_MOFIFY_ROW etc . I have seen for LOP_SHRINK_NOOP.

Thanks...Arshad

It backups the other databases. I asked it not to ignore any , but still leaves out the one in the Availability Group?  thank you

@michael-2 , No its not backing the Primary Up...It ignores it (Though I unchecked the option 'Ignore Databases that are  Not Online')..I get the warming you mentioned above...

• This reply was modified 2 years, 4 months ago by  Arsh.

@Ant-Green Yes ,  Log backups are helping to have a control on the file size. Also, I had found some default trace was running , so stopped that too...Looks fine...

@Ant-Green  Is this increase in the log-file size normal in Read-Scale ? The actual log-file size is just over 0.5 GB only. There are no drastic changes at the application...

Hi Brahmand,

Yes , its strange , given the size of the Database itself..The logfile eventually went to its fullest of 20GB...As the Drive was full, I had to move the...

• This reply was modified 2 years, 5 months ago by  Arsh.
• This reply was modified 2 years, 5 months ago by  Arsh.

Hi Michael,

Thanks for pointing this. I did configure them and now it works...Thank you.

Best Regards..Arshad

• This reply was modified 2 years, 5 months ago by  Arsh.