Failed Maintenance Plan problem due to Allow Updates change. - SQL Server
The failure of the late night database backup and transaction log backup as part of our maintenance plans, prompted investigation.
The maintenance logs revealed the following error:- 'Failed:(0) Alter failed for [Server Name]'
The error messages about the failure did not provide much in the way of useful information.
After further investigation, the solution was to change the 'Allow Updates' setting back from 1 to 0. Use the following T-SQL:-
The failure of the late night database backup and transaction log backup as part of our maintenance plans, prompted investigation.
The maintenance logs revealed the following error:- 'Failed:(0) Alter failed for [Server Name]'
The error messages about the failure did not provide much in the way of useful information.
After further investigation, the solution was to change the 'Allow Updates' setting back from 1 to 0. Use the following T-SQL:-
sp_configure "Allow Updates", 1
GO
reconfigure with override
GO
---------------------------------------------------
related links
sp_configure:- http://msdn.microsoft.com/en-us/library/ms188787.aspx
No comments:
Post a Comment