Setup has detected a non canonical discretionary access control list (DACL) on directory ‘c:Program FilesMicrosoft SQL Server100DTS’. Please veirfy your security settings and make corrections if needed. Its ultimately a security issue that seems to result from having 1 version of SQL Server installed (in…

Login to SSIS on server with plans to export Navigate to Stored Packages – MSDB – Maintenance Plans Right click on the maintenance plan you want to export – choose Export Package Choose package location (I usually use File System for easy transfer to another…

only need to backup transaction logs on any databases that are regularly changing – not master, model, etc…  those system databases can be backed up once per night

Unable to start execution of step 1 (reason: line(1): Syntax error).  The step failed. Fixed by: Editing the job by add a leading “” to the package path so that is reads:  Maintenance PlansPlanName Steps: Right click the MaintenancePlan under SQL Server AgentsJobs and click…