Manoj Patil
asked on
Backup of SQL SERVER DATABASE FILE FROM C#.NET
I am creating windows application in c#.NET. and I want to take database backup daily and upload to Domain Server with providing FTP Details automatically.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sure , you can do that with the at command
see
http://technet.microsoft.com/en-us/library/cc755618%28WS.10%29.aspx
see
http://technet.microsoft.com/en-us/library/cc755618%28WS.10%29.aspx
or use a more robust command
http://technet.microsoft.com/en-us/library/cc772785%28WS.10%29.aspx
http://technet.microsoft.com/en-us/library/cc772785%28WS.10%29.aspx
Example
assuming that your script is under c:\ this will run the task each day at 08:00
schtasks /create /tn "DBBackupJob" /tr c:\\backup.cmd /sc daily /st 08:00
assuming that your script is under c:\ this will run the task each day at 08:00
schtasks /create /tn "DBBackupJob" /tr c:\\backup.cmd /sc daily /st 08:00
ASKER
Its Helpfull, but is there any way to add scheduler in software, sh when he start software it will automatically start the task.