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 |
|
mrose1120
Starting Member
11 Posts |
 Posted - 2006-09-20 : 17:24:11
|
| Hey everyone,I'm trying to setup backups in my environment differently. right now, we backup using a maintenance plan to a direcetory on the SQL server and then Veritas connects via a remote agent to the server and backs up that directory. I'm trying to setup a batch file to copy those files to a file server. This would enable us to not have to have Veritas connect to multiple servers just to back up certain files. Problem is, I made a batch file, which works perfectly when I run it from a command prompt, but not once I put it in scheduled tasks on Server 2003. I have it running as a domain user which has access to the remote folder and I even gave it access to the local pc. It is a member of the log on as batch file security policy, but the only way it runs is if I put the user in the local admins group. Is anyone else doing something similar to this? If so, how did you fix it? Thanks. |
|
|
EugeneZ
Starting Member
26 Posts |
Posted - 2006-09-21 : 08:31:12
|
| try to put the MS-Dos command as "next step" in sql agent job backup after backup step is done>-- Just make sure sql server service account has NTFS rights on destination folder on file server---Also post, please, an error that you got from Win3k scheduled tasks |
 |
|
|
|
|
|
Need backup help