Run Barch in SQL Server problem - share drive???

Hello Guys,

I have a problem with a job moving and zipping file to share drive


What does my Batch?



1)       Copy backup device (initially in D:/) into
//SERVER/SHARE/Archived_Backups/

2)       Create new folder in //SERVER/SHARE/Archived_Backups/

3)       Move the DEVICE into this new folder

4)       Zip the DEVICE and named it today.zip


if I run it manually the batch file works perfectly, But if I launch it
with sql server (what I would like to perform) this step does not run
perfectly.

What does this job?

1)     run the batch
Step 1
DECLARE @cmd sysname, @var sysname
SET @var = 'start D:\Backups\MyBacth.bat'
EXEC master..xp_cmdshell @var

2)       Overwrite the DEVICE

3)       Verify DEVICE integrity


I have already set privileges for sqlservice in to this share


What do i need to do??? Any Suggestions?


Thanks in advance



Ina

Hi

Apart from the typo in your script! You don't say what the SQL Agent account
is running as and if it has network privileges.

John

"ina" wrote:

> Hello Guys,
>
> I have a problem with a job moving and zipping file to share drive
>
>
> What does my Batch?
>
>
>
> 1)       Copy backup device (initially in D:/) into
> //SERVER/SHARE/Archived_Backups/
>
> 2)       Create new folder in //SERVER/SHARE/Archived_Backups/
>
> 3)       Move the DEVICE into this new folder
>
> 4)       Zip the DEVICE and named it today.zip
>
>
> if I run it manually the batch file works perfectly, But if I launch it
> with sql server (what I would like to perform) this step does not run
> perfectly.
>
> What does this job?
>
> 1)     run the batch
> Step 1
> DECLARE @cmd sysname, @var sysname
> SET @var = 'start D:\Backups\MyBacth.bat'
> EXEC master..xp_cmdshell @var
>
> 2)       Overwrite the DEVICE
>
> 3)       Verify DEVICE integrity
>
>
> I have already set privileges for sqlservice in to this share
>
>
> What do i need to do??? Any Suggestions?
>
>
> Thanks in advance
>
>
>
> Ina
>
>