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