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