Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: DBCC TABLE CHECK

    I am planning to have checkDB weeekly but not running every 2-3 hours.

  • RE: DBCC TABLE CHECK

    Thanks for all the input., that what I thought about DBCC check TABLE is from DBCC CHECK DB. There was no user that had privilege to run DBCC check...

  • RE: dbcc checkDB

    when I run sp_who, I found multiple processes with the same spid running DBCC CHECK TABLE (some of the processes are "suspended" and some are "runnable", I should be able...

  • RE: Error 18456 Severity 14 State 38

    ok, I found out the job came from one of the incremental backup job and I have no idea which could trigger the log backup to run every 5 min...

  • RE: Error 18456 Severity 14 State 38

    it came out from SQL agent. SQL agent service running as this act. To be more specific, I think the error came out from either update job activity,...

  • RE: Error 18456 Severity 14 State 38

    Thanks for your prompt reply.

    default DBs for this user is 'master' and this acct does have admin privs, indeed it's svc acct that run SQL.

    I completely agreed with...

Viewing 6 posts - 1 through 6 (of 6 total)