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

system DB backups in maintenance plans/jobs stopped working when "show advanced features" was on Expand / Collapse
Posted Wednesday, April 9, 2014 6:52 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 30, 2015 11:17 AM
Points: 42, Visits: 140
Our backup job of all the system databases in a sql server 2005 maintenance plan stopped working without giving any explicit or detailed error message except "failed to execute package".
We noticed we had neglected to turn "show advanced features" config option back to 0.
The jobs worked fine again when we set the option to 0.
Is this a bug, or planned?
Does anyone know of any other things that won't work while the option is on/set to 1?
Is it the same in more recent versions of sql server?
If it's a bug, is it fixed in any newer versions?
Any information you could supply would be much appreciated.
Post #1559914
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse