Solved

Running o/s job though sql server

Posted on 2011-09-27
2
162 Views
Last Modified: 2012-06-27
Hi,

I am running a job through sql server and get the error below when trying to copy across a remote server as below - any ideas why i get the error ?


Job 'Restore CSS Reporting' : Step 1, 'Copy Production CSS' : Began Executing 2011-09-27 15:51:51

output                                                                                                                                                                                                                                                        
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(null)
C:\WINDOWS\system32>echo wscript.echo year(date) & right(100 + month(date),2) & right(100+day(date),2)   1>"C:\WINDOWS\TEMP\dateparts.vbs"
(null)
C:\WINDOWS\system32>for /F "tokens=1 delims=" %a in ('cscript //nologo "C:\WINDOWS\TEMP\dateparts.vbs"') do set yyyymmdd=%a
(null)
C:\WINDOWS\system32>set yyyymmdd=20110927
(null)
C:\WINDOWS\system32>copy \\10.6.206.88\d$\mssql\backup\css\CSS_db_201109271349.BAK D:\mssql\mssql\Restore\cssprod.bak
Access is denied.
(null)
0
Comment
Question by:hraja77
2 Comments
 
LVL 25

Expert Comment

by:TempDBA
ID: 36710353
there is a permission problem. Check for all the required permission for the a/c running job (job_owner) on the destination\remote folder.
0
 
LVL 8

Accepted Solution

by:
venk_r earned 500 total points
ID: 36712032
Make sure the account in which SQL Server sevice is running under  is having permissions on the remote folder.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to enforce inte 8 52
execute a MS SQL script as a schedule SQL job 72 129
Why is the output of this function is like this? 4 34
SQL Query with Sum and Detail rows 2 50
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question