Powershell with MS SQL Copy-item to network drive

Asked Jan 13 '17 at 12:01

Active Jan 13 '17 at 12:04

Viewed 442 times

I have a script that runs perfectly in a Job step of MS SQL besides one command. With this command:

Copy-Item C:\Test\My_file.txt  \\NETWORK\FOLDER\DATA

This doesnt work in Powershell.exe.

I have tried also this:

$destination = "\\NETWORK\FOLDER\DATA"
Copy-Item C:\Test\My_file.txt $destination

When I run file where these lines are written, Powershell.exe works fine.

But But it doesnt work. Dont you know what can be a problem with copying to Network drive?

Thank you.

edited Jan 13 '17 at 12:04

asked Jan 13 '17 at 12:01

HeadOverFeet

1

Probably the account under which the job is executed? – Martin Brandl Jan 13 '17 at 12:04
Most likely it's the permissions on the network location for the user executing the script - I assume it's part of a backup procedure run by the SQL Agent user. – Filburt Jan 13 '17 at 12:04
Dont you know how can it be checked? :) – HeadOverFeet Jan 13 '17 at 12:05
Are you getting any errors ? If you do, please post them. – YanivK Jan 13 '17 at 12:19
No, no errors .. It seems everything was successfully ended – HeadOverFeet Jan 13 '17 at 12:35
1

[Related](http://stackoverflow.com/q/41617778/1630171). – Ansgar Wiechers Jan 13 '17 at 21:31
@AnsgarWiechers thank you for a suggestion, I will try it tomorrow :) – HeadOverFeet Jan 13 '17 at 21:34

0 Answers0