October 16, 2003 at 3:45 pm
Hi all,
I have sql7.00.1077 on win 5.0 sp3.
I created two maintenance plans, one for sustem DB, one for user DB. The sys db backup no problem, but the user db backup failed. The error message says 'The system cannot find the path specified'. When I create the plan I just browser the local disk. Later I checked the path, no problem.
But still have the error. Then I backed up the DB from QA, it is OK. I thought maybe the permission problem, I set up the permission then run the job again, it still failed. What it the problem? Anybody has the same problem?
Please advise. Thanks!
Robert
October 17, 2003 at 2:39 am
I guess you are right that it is a permission problem. Did you check the permissions of the windows user that runs the SQLServer agent?
October 17, 2003 at 5:35 am
Remember the job is running under the account that the SQL Server AGENT SERVICE is running as. Does that account have access to the database files?
-SQLBill
October 17, 2003 at 9:37 am
Are you writing it to the same physical server? If not, try accessing the path from a separate (non-biased) system. It could be the path. Also have seen problems where the account does not have access to send data across the network -- this has to be fixed in the policy.
Joe Johnson
NETDIO,LLC.
Joe Johnson
NETDIO,LLC.
October 17, 2003 at 9:40 am
oops. Just re-read the issue. Who is the owner of the user db?
Joe Johnson
NETDIO,LLC.
Joe Johnson
NETDIO,LLC.
October 17, 2003 at 1:13 pm
Hi All,
Thanks for your reply.
It is on local server disk. I checked the permissionfor both sql server services and agent, even diak permission. My user name is member of sa and dbo. Funny thing is the plan has two user db, one backup is ok, one is failed. any thoughts? Please advise. Thanks!
Robert
October 17, 2003 at 3:58 pm
Hi All,
I created a job from right click database-all tasks-backup database and it works. So maybe there is a bug in the maintenance plan. Can anyone explain it? Thanks!
Robert
October 20, 2003 at 9:02 am
Just a though, Why would we use maintenance plan? How do we know if 1 or all of the backup job failed? If you were to set up each database individually, then you know exactly which one fail or succeed. This way we can restart the job that failed.
mom
October 20, 2003 at 9:59 am
What Authentication method are you using?
Did you have any errors ?
Mike
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply