dvendt

Is there a way to run a scheduled task, let's say a batch file consisting of xcopy from Server A to Server B (using net use in batch) when these servers are each in workgroup, no domain. Server A = w2k server, Server B = w2k3 server. The batch file runs ok from command line. Thanks!

djaburg

There is, depending on the OS. With most it will be in the control panel, scheduled tasks. Once in there, just create the event you need and have it run. I would ensure that your .bat file runs without error prior to scheduling it.

I did something similar using rsync for windows, and it replicated several shared directories from one server to a backup server. The client didn't want to go the route of a clustered server with shared storage so I came up with this way. There was also a log file created that allowed me to see what files were and weren't copied. I think it worked better than xcopy because xcopy will do a full copy all the time, whereas rsync will sync all the first time and then only changed thereafter. That effectively reduces the time for the backup. Heck, I even had the .bat file shutdown their mssql service running for their Act! program, had it backup the database directories, and restart the service. Has run flawless for more than a year.

Extraction

Go to start -> all programs -> accessories -> system tools -> scheduled tasks.

Also if your copying files from one computer to another over a network use robocopy instead of xcopy. It is a free utility from Microsoft that is basically the same as xcopy but with network support / reliability built in.

bilbus

sure, just issue a "net use" command to map a drive (NET USE J: \\servername\share /USER:domainname\username password)

That will log you in and map a a drive (if needed) but you can also just use it toget you logged in and still use a UNC name.

dvendt

For some reason, this does not work in Scheduled tasks, it runs fine manually when I run it from command prompt. Here is the bat file contents, very simple, but does not work. Now, the xcopy process takes over 2 hours on this. I noticed the scheduled tasks result is 0x0, which is ok and the log shows that it ran, but it did not. Any ideas?

net use f: \\192.168.1.101\f$ /user:server1\administrator password
start "SQL COPY" /min xcopy "c:\program files\microsoft sql server\mssql\backup\*.*" f:\backups\backup09\*.*

bilbus

you can't use the drive letter in Scheduled tasks

I only maped it so you could auth the user, once access is granted, you need to \\server\share

dvendt

Tks for the reply, looks like it worked.

bilbus

good to hear