@Sridevi kakolu,

Thanks for the reply and the referenced material . I was worked with this option for many PTO tasks, but what I am looking for is , a query...

Thank you Ant-Green. I have changed the maintenance plan and categorized the indexes rather into Rebuild and Reorganized categories depending on which side they fall on the 30% mark replacing...

Hi,

looking at other side of it, is there a way to reclaim the space on the drive after Index Rebuild ? thank you.

Thanks everyone for your advices..I did a Rebuild of only selected indexes , with a frag percent more than 30% unlike the earlier maintenance plan that had a blanket Rebuild...

Dear All,

Firstly , Thank you to all of you sharing your knowledge..The issue was with an Agent Jjob for Index Rebuild , done for all the Indexes irrespective of the...

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

@Ant-green

The setting is 1000 and 100 respectively. Interestingly a newly instance I recently setup on the same server , (with both having identical settings above ),writes the history. More interesting...

Hi All,

It was a permissions issue of the SQL server agent account on the directory . It couldn't write even being an administrator..I added specifically and it worked. However, though...

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...