Windows Server - 2008 server job scheduler to run robocopy
Asked By FRED SHIKE
23-Apr-09 03:56 PM
Trying to schedule a job using the job scheduler on a microsoft 2008 server. Below is the command I am trying to run. It works manually on the command prompt but will not work in the job scheduler. Drive z: is a mapped drive on the backup server, the actual drive letter is d:. I am trying to backup a shared drive on the main server to a shared drive on the backup server every nightly.
robocopy d:\shared\sus\ z:\\valley2\sqlbackups /copyall
Santhosh N replied to FRED SHIKE
Check this if it works for you...
http://forums.techarena.in/server-scripting/796498.htm
create a .bat file and then execute
the batch file throguh windows scheduler
@Echo off
robocopy "C:\Pictures Working Directory" "D:\PhotoBackup" /E /ETA /Z /PURGE
Goto Defrag
:Defrag
defrag c:
defrag d:
Goto Done
:Done
Echo Done
Pause
save the aboe code as .bat and then schedule in windows tasks.
Hope this works!
Cheers
10:25.0731] [0] * ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** * [11 / 17 / 2011 19:10:25.0731] [0] Starting Microsoft Exchange Server 2010 Setup [11 / 17 / 2011 19:10:25.0731] [0] * ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** * [11 / 17 / 2011 19:10 Time (US & Canada). [11 / 17 / 2011 19:10:25.0731] [0] Operating System version: Microsoft Windows NT 6.1.7601 Service Pack 1. [11 / 17 / 2011 19:10:25.0731] [0 catalog. . . [11 / 17 / 2011 19:10:27.0119] [0] Setup has chosen the global catalog server HS.mr238.org. [11 / 17 / 2011 19:10:27.0119] [0] Setup will use the org'. [11 / 17 / 2011 19:10:27.0182] [0] Setup will search for an Exchange Server object for the local machine with name 'EXCHANGE'. [11 / 17 / 2011 19:10:27.0213] [0] Exchange Server object found : 'CN = EXCHANGE, CN = Servers, CN = Exchange Administrative Group (FYDIBOHF23SPDLT), CN = Administrative Groups, CN are installed: BridgeheadRole MailboxRole AdminToolsRole [11 / 17 / 2011 19:10:27.0260] [0] The local server has some Exchange files installed. [11 / 17 / 2011 19:10:27.0416] [0] Setup will 11 / 17 / 2011 19:10:27.0416] [0] Setup will discover the installed roles from server object 'CN = EXCHANGE, CN = Servers, CN = Exchange Administrative Group (FYDIBOHF23SPDLT), CN = Administrative Groups, CN = First DC = org'. [11 / 17 / 2011 19:10:27.0416] [0] 'BridgeheadRole' is installed on the server object. [11 / 17 / 2011 19:10:27.0416] [0] 'MailboxRole' is installed on the server
How to take backup in online sql server express edition? Hi, How to take backup in online sqlserver 2005 express edition? Plz guide me. Thanks & Regards Toral Shah SQL Server Express Edition lacks of SQL Agent which is the responsible for scheduling maintenance jobs such tasks by one of the following ways: - Create a custom script and run it from windows scheduler. - Trying some third party tool. I recommend you to try SQL Backup and FTP which has a free edition that lets you schedule up to 2 databases if you don't have so much experience. You could use a combination of the Windows Scheduler service, SQLCmd.exe, and stored procedures. OR, you could explore this project and determine
SQL Express 2008 Scheduler or Agent Hi, Can anyone recommend a preferably free scheduler or Agent type clone to run TSQL scripts on SQL Express 2008 on XP? I have tried using "SQLScheduler.exe" which works. Just wondering if anyone can solutions for running schedule tasks in SQL Express is to use a Task in the Windows Task Scheduler to call SQLCmd and run the script you want to run . You can set schedules, etc. using Windows Tasks. Cuz as know, SQL Express does not include the SQL Agent, which is the Editions of SQL use to schedule jobs. Also, see if you could create your own scheduler framework, a sample is described here Hi, The solution provided with this article is composed
Windows 7 clients have APP CRASH every night between 6:00 - 9:00 Our server is SBS 2008. Every night, the few users who are still working will have an APP CRASH (error databases. Excel will crash when a user tries to save the open document to the server. Quickbooks has crashed I suspect when the user has a file open from the server. It seems like the Windows 7 clients are losing their connection to the server. After the apps crash, the user can usually just restart the app and continue working I see no events in either the server logs or the workstation logs leading up to the crash. There are no error messages