Thanks Steve - Can confirm the following… [DOMAIN-HOME]/bi/tmp was indeed filling up whilst the export was running. On Failure the files are deleted so you cant see the space consumed unless you monitor during the export.

Thanks for the comment, I was limited to the Presentation services only in this case

just to close this off, I managed to accomplish what I needed , fortunately LTS was tied to a specific database so this worked : SET VARIABLE DISABLE_CACHE_HIT=1, INACTIVE_SCHEMAS='"<RPD Phy DB Name>".."<RPD Phys Schema Name"';