|
Home > Archive > MS SQL Server > November 2006 > Run Barch in SQL Server problem - share drive???
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| John Bell 2006-11-30, 7:14 pm |
| 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
>
>
|
|
|
|
|