Prev: sqlserver to mysql data transfer of image column
Next: Lock pages in memory greyed out
From: bcap on 3 May 2010 11:41
Hi,

I am trying to create a Job in SQL Server 2005 and have an output file
being sent to a local directory. I can do this no problem by sending
the file to a local directory, but when I try to send this to a
Network directory, the process still runs successfully but the file
does not show in the specificed network drive. Is it possible to send
files this way? Below is how I am sending it to the Network
Directory.

‘\\myservername\global$\myfiles\”

Any thoughts and/or suggestions would greatly be apprciated and thank
you in advance for any help!
From: John Bell on 3 May 2010 16:17
Replied in .programming
From: Geoff Schaller on 3 May 2010 18:12
Hello anonymous,

You can only send and use files from dives that are physically attached
to the server as local drives. Yo must move them yourself from there.
The same goes for backup and restore etc.

Cheers,

Geoff Schaller
Software Objectives


"bcap" <rayh(a)patriots.com> wrote in message
news:49439e73-14cf-4e30-8714-e1a22359785a(a)z33g2000vbb.googlegroups.com:

> Hi,
>
> I am trying to create a Job in SQL Server 2005 and have an output file
> being sent to a local directory. I can do this no problem by sending
> the file to a local directory, but when I try to send this to a
> Network directory, the process still runs successfully but the file
> does not show in the specificed network drive. Is it possible to send
> files this way? Below is how I am sending it to the Network
> Directory.
>
> '\\myservername\global$\myfiles\"
>
> Any thoughts and/or suggestions would greatly be apprciated and thank
> you in advance for any help!

From: Mike on 7 May 2010 13:42
I am doing the same thing and had the same problem. The folder must be
shared on the network and the permissions will need set on the destination
server to allow a) the 'system' user group and b) the sql server to have
access.

In your example say you have \\sql and \\myservername\global$\myfiles.
myfiles on \\myservername will need to be shared
security on the shared folder would need set allow the 'system' user group
and 'domain\sql$' (where domain is the name of your domain and sql is the
name of your sql server) to have full access.

It will work.

"bcap" <rayh(a)patriots.com> wrote in message
news:49439e73-14cf-4e30-8714-e1a22359785a(a)z33g2000vbb.googlegroups.com...
> Hi,
>
> I am trying to create a Job in SQL Server 2005 and have an output file
> being sent to a local directory. I can do this no problem by sending
> the file to a local directory, but when I try to send this to a
> Network directory, the process still runs successfully but the file
> does not show in the specificed network drive. Is it possible to send
> files this way? Below is how I am sending it to the Network
> Directory.
>
> �\\myservername\global$\myfiles\�
>
> Any thoughts and/or suggestions would greatly be apprciated and thank
> you in advance for any help!

 | 
Pages: 1
Prev: sqlserver to mysql data transfer of image column
Next: Lock pages in memory greyed out