I am taking backups for all databases using Maintenance plan on shared machine. While doing so it producing error like as below:
Executed as user: Source: Back Up Database (Full) Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_create_subdir
N'\\SQLdatabase\backup" failed with the following error: "xp_create_subdir() returned error 183, 'Cannot create a file when that file already exists.'".
SQL server Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Source: Back Up Database (Full) Execute SQL Task Description: Executing the query "BACKUP DATABASE [master] TO DISK failed with the following error: "Cannot open backup device Operating system error 5 Access is denied.
Note: SQLServerServiceAcct & AgentAcct has full controll or admin rights on the folders where backups gets stored.