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
Author
Message
Posted Wednesday, April 9, 2014 6:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 12:56 PM
Points: 21, Visits: 89
Hello.
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