Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Maint job fails with "error cannot drop statistics _W_Sys_xxx.." ......... Expand / Collapse
Author
Message
Posted Sunday, May 26, 2013 2:46 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 18, 2014 8:25 AM
Points: 1,519, Visits: 2,550
Hello,

One of our weekly maintenance job which was running fine failed last 2-3 times. In the log we see the error message as "... cannot drop statistics _W_Sys_xxx.." somthing like that.. I don't understand why is it trying to drop those statistics which do not exist... Can anyone shed some lights on this please ??

Thanks in advance..

Smith.
Post #1456846
Posted Sunday, May 26, 2013 4:06 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:52 AM
Points: 42,803, Visits: 35,919
Without seeing what the maintenance job does and why it's trying to delete statistics in the first place, no way to say.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1456850
Posted Sunday, May 26, 2013 4:32 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 18, 2014 8:25 AM
Points: 1,519, Visits: 2,550
Gila,

Thanks for the quick response...
It's for rebuilding the indexes.. nothing else..

Smith.
Post #1456853
Posted Sunday, May 26, 2013 4:39 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:52 AM
Points: 42,803, Visits: 35,919
Without seeing the details and specifics of what the maint plan does, it's going to be near-impossible to answer this.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1456854
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse