Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
askcomputer
Starting Member
12 Posts |
 Posted - 2007-03-28 : 02:40:45
|
| HiI created one database Maintenance Plan there i am using complete database backup. For backup file save purpose i am using remote machine path(\\xyz\f\app_backup\). After execute job i am getting error as below mention:The job failed. The Job was invoked by Schedule 18 (Schedule 1). The last step to run was step 1 (Step 1).Please help how solve this problem.RegardsSantosh |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2007-03-28 : 02:54:07
|
| It seems like you are running sql server using local account. So, might be a case that its not allowing u to copy backup in a network path. But still I will recommend to check the error, encountered by the job. Right click the job, and view history for error and post the description here.regardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
 |
|
|
askcomputer
Starting Member
12 Posts |
Posted - 2007-03-28 : 03:04:17
|
Thanks Sachin for reply.I mention below job history msg.:The job failed. The Job was invoked by Schedule 18 (Schedule 1). The last step to run was step 1 (Step 1).Executed as user: NETWORK\user. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.Please suggest.RegardsSantoshquote:
Originally posted by sachinsamuel
It seems like you are running sql server using local account. So, might be a case that its not allowing u to copy backup in a network path. But still I will recommend to check the error, encountered by the job. Right click the job, and view history for error and post the description here.regardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu
|
|
|
|
|
|
|
The job failed The Job was invoked by Schedule 18