Problem : I have faced one issue which was access denied type error . I am able to take Backup manually but when I am trying to set it through maintenance job then its show below Error. Executing the query "EXECUTE testDB.dbo.xp_create_subdir N'D:\DBBackup..." failed with the following error: "xp_create_subdir() returned error 5, 'Access is denied.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Solution :.I resolved above error by providing full right for user everyone to folder DBBackup. To give rights to folder you can follow steps as below. 1.Select folder Properties and select the Tab Security 2.Now click Add buton then click on Advanced button. 3.Then click Find Now and select Everyone then click ok.
ERP Project Management,Asp.net,PL SQL Tips for error resolution,Research,Software Errors and solution,SQL 2014,2012,2008,Procedural language,SP,Power BI,excel macro ,Musical notations,Business software,Degree, diploma related informations.