Xp move files not copy

Sometimes database professionals need to perform specific tasks at the operating system level. These tasks can be like copying, moving, deleting files and folders.

A use case of these tasks might be removing the old backup files or copying backup files to a specific directory after a particular time. You need a sysadmin role or proxy account configured to use this extended procedure.

We can also use the SSIS package for the file transfer, but it also requires you to build a package with the relevant tasks. This extended stored procedure is available in the master database. Suppose we require copying files from one folder to another. The below script removes a file script. To copy a single file from the source to the destination folder, we use sys. Specify the source and destination path in the query argument. To explore the stored procedure further, create a notepad file in the source directory and write some text in it.

What YOU can do does not matter. What matters are the permissions that the account being used to run SQL Server holds. If the service account does not have the proper permissions to the folders, then you will get this error.

Without a domain, you can grant permissions to the everyone group on these folders, but that's probably not a good solution. I would not recommend the "everyone" group as then anybody who can get access to the machine has access to those folders.

I cannot remember offhand runs as so you can set the permissions properly. I'd change it then to a real user instead of any built-in users.

I don't like using any built-in accounts for anything like that plus any "NT anything" accounts are tricky to get working across a network. Same thing with "Local Service". But I think another part of the problem in this case is that it's using admin shares and this probably requires creating a regular file share. And then granting permissions to that share. Those are virtual accounts. Check this article which explains it more - the section under Virtual Accounts. It also explains how to grant network access using the machine account.

If the file is on a network share instead of a local drive, make sure that the sufficient permissions are set on the share itself as well.

File permissions are checked after share permissions, so if the file allows "Modify", but the share only allows "Read", the overall permissions will still be "Read". As mentioned above, it missed the permission. If it is root directory, this cannot be applied. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more.

Asked 12 years, 11 months ago. Active 1 year, 10 months ago. Viewed 23k times. Access is denied. Im logged into the server as local administrator. Maksym Gontar Add a comment.