26 August 2019

D365FO: delete SQL backup file without admin rights

As you know, some time ago Microsoft implemented restricted access to sandbox VMs hosted in Microsoft subscription, including developer and build environments. As a result, default non-admin user could not delete SQL backups, made by SQL Management Studio, from "J:\MSSQL_BACKUP" folder via File Explorer.

The workaround is to use SQL Management Studio, run the query below with a path to a file you want to delete:


EXECUTE master.dbo.xp_delete_file 0,N'J:\MSSQL_BACKUP\AXDB.bak'



No comments:

Post a Comment