Hi EMarkM

Tq for the below tips :

"Extra check: to make sure that the sproc has indeed been installed, expand Server > Databases > master > Programmability > Stored Procedures and...

Yes you are right

The script sp_AskBrent already include with create store procedure statement. I just notice this.

I just double click sp_AskBrent and execute it using SSMS.

Once execute, the SP will...

Hi SSC-Enthusiastic

Logically:

1. I am using SQL agent services tu run the maintenance task for full backup and backup log

2. The location for both task located at same location which is...

in order to reset SA password i dont think required downtime

Hi

I have this output after run this script.

servername ...

Thanks bro...i will crosscheck with my infra team regarding the backup exec...I have a strong feeling this are the 3rd party backup solution that triggering dbcc checkdb

if you have another users that have similar roles with SA (sysadmin roles), just simply login what that users and change the current sa password

Hi monster, based on the link that you provide:

1. I did not restart or shutdown the database instance

2. The dbcc checkdb will keep popping out the sql server log message...