Thursday, March 21, 2013

Maitanance Plan fails with error:Alter failed for Server 'servername'.




Hi , Today morning i saw my maintenance plan job to do differential backups got failed and i saw the error
Alter failed for Server 'servername'., oops i never saw this error , tried  goggling and found some help

so what happened was my Windows team  changed the CPU I/O Affinity settings and which made the changes to SQL Server

So to get your any maintenance plan running go ahead and run:
    sp_configure 'allow updates', 0

    reconfigure with override


and execute the Maintenance Job , it will run successfully  

Thanks
03/21/2013

No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...