|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/30/2011
Posts: 3
Location: Thessaloniki Greece
|
Hello,
I have installed the free version of "Sql Backup And FTP" to my Server machine(Windows Server 2003). I try to take a scheduled backup (every day) for my database to my terminal Server (again Windows Server 2003). I had configured it but the auto scheduled backup is not working.
Any ideas?
Firewall parameters?
Is it something extra that I must do for Windows Server?
The last result in Scheduled task is "0xffff".
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
See if this solves the problem: http://zetconsultants.com/blog/?p=44
Or check the log (see how: http://support.microsoft.com/kb/308558) for a detailed error message.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/30/2011
Posts: 3
Location: Thessaloniki Greece
|
Thank you very much. The error in Event Viewer is Operating System error 112 on MSSQLSERVER. What is 112 Operating system error? Thank you in advance camco attached the following image(s):
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
I'm not sure that this error is related to our program. Do you have any records in your Windows Event Log related to "SqlBackupAndFtp" source?
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/30/2011
Posts: 3
Location: Thessaloniki Greece
|
Yes, but as I can see...your program make a backup at C:\Windows\Temp and then transfer it to the network path. I don't have enough hard disk space in C:\.(that's the meaning of Operating System error-112). Therefore, I configured your parameter about large backups in advanced settings.I choose another hard disk to my server and then transfer it to my terminal server. I solved my problem. Thanks a lot!
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
You're welcome. I'm glad that you have solved it.
|
|
|
|
|
