Viewing 6 posts - 1 through 6 (of 6 total)
I am planning to have checkDB weeekly but not running every 2-3 hours.
March 1, 2012 at 9:56 am
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...
March 1, 2012 at 9:44 am
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...
February 29, 2012 at 10:17 am
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...
November 4, 2011 at 9:40 am
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,...
November 3, 2011 at 2:31 pm
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...
November 3, 2011 at 7:19 am
Viewing 6 posts - 1 through 6 (of 6 total)