CODEWITHSUNDEEP
windowssql-server-2008-r2scheduled-tasksadminsystem-administration
Nitesh Kumar
Nitesh Kumar

Reputation: 885

Windows task schedular not execution job properly?

I have a sql server 2008 R2 express edition . I have written a batch file which backup all of my database of the express edition. It is working fine by execution manually. I had scheduled this batch file in a task in task scheduler but the issue it is not working properly from task scheduler . Only lesser no of databases are being backup or some times it does not. I am not able to find any error in the script or task scheduler .

Please let me know how can I resolve this issue.

Thanks,

Nitesh Kumar

Upvotes: 0

Views: 230

Answers (1)

Alexey
Alexey

Reputation: 1904

You can schedule database backup with a specified user using our SQLBackupAndFTP tool. There is possibility to create backup jobs for Windows Scheduler or use its own scheduler service (full, differential and transaction log backups).

Upvotes: 1

Related Questions