|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/5/2011
Posts: 9
|
When I run all of my jobs manually, they work fine. However, when I try to run then via schedule, all jobs fail. I am doing an advanced schedule and using the SQLBackupandFTP service rather than Windows scheduler. The messages in my Windows event log are:
"Starting diff backup for E:\Mirror_Data\NextechBU.jobx using C:\Program Files\Pranas.NET\SQLBackupAndFTP\SQLBackupAndFTP.exe under cfrbs\stchas_admin"
Followed by
"Can't logon as stchas_admin: LogonU: Logon failure: unknown user name or bad password."
The user account stchas_admin is a domain administrator and the database owner of the target database.
I am stumped.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
In cfrbs\stchas_admin, cfrbs is a domain name or a local PC name?
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/5/2011
Posts: 9
|
cfrbs\stchas_admin is a domain admin. This process works if I use Windows Scheduling. It just does not work with SQLBackupandFTP scheduler.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
Yes, it seems to be a problem. Give us a little time to explore it please.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/5/2011
Posts: 9
|
I still have not heard back and the problem is still there.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
We tried to reproduce this problem and everything worked fine on our side. So we need some additional info:
1) when you save the scheduled job does the program warn you about any problems after you enter a password?
2) are you able to run the job via the SBF Scheduler under some other user account (for example, under a local one)?
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/5/2011
Posts: 9
|
1) There are no warnings about the password
2) Cannot run it under SBF scheduler under any ID. I even tried creating a local admin account just for it and running it. I get the same error.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
Ok, then what happens if you run the job under a LOCAL SYSTEM account (i.e. not specifying any account in advanced settings at all)? (in this case the service uses a different method to start the program and this error should not appear)
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/5/2011
Posts: 9
|
I could not even run one of my existing jobs with the Local System Account. It kept asking for an ID and Password. I created a new job with full backup once a day and incremental backup every hour. The inital job ran just fine and so did the first increment. I think it is safe to say that it will run.
So, now the issue is, how do I get this to work with a domain account that has access to my secure server over the network? The Local System backup only works if I am backing up to a share on the local machine.
Thanks
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
I'm a bit confused, before you wrote Quote:Cannot run it under SBF scheduler under any ID. I even tried creating a local admin account just for it and running it. I get the same error. and now you say Quote:The inital job ran just fine and so did the first increment. I think it is safe to say that it will run. So does it work with a local account or not? Could you please clarify?
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/5/2011
Posts: 9
|
It works under local system (name left blank) but does not work with any named account whether it is a local account or a domain account, regardless of the authority of that account.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
Ok, I see now. Please tell then what's your OS (Windows version)?
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/5/2011
Posts: 9
|
Windows Server 2003 Enterprise. Also, when running under the Local System Account I am receiving the following error on the differential backups:
SqlBackupAndFtp 6.0.10.34881 Professional (run as service)
SUMMARY:
Database Clinic_Rolodex: Backup - Failure
DETAILED LOG:
9/1/2011 7:16:58 PM Creating backup of Clinic_Rolodex to E:\Temp_BU (differential)
9/1/2011 7:17:02 PM Backup of Clinic_Rolodex completed
9/1/2011 7:17:02 PM Zipping E:\Temp_BU\Clinic_Rolodex201109011917diff.bak to E:\Mirror_Data\Clinic_Rolodex201109011917diff.zip
9/1/2011 7:17:03 PM ERROR: Zip failed: The file could not be deleted because it is currently in use.
Type: Xceed.FileSystem.DiskFile
FullName: E:\Mirror_Data\Clinic_Rolodex201109011917diff.zip
9/1/2011 7:17:03 PM Removing the backup: E:\Temp_BU\Clinic_Rolodex201109011917diff.bak
9/1/2011 7:17:03 PM ERROR: Removing failed: The process cannot access the file 'E:\Temp_BU\Clinic_Rolodex201109011917diff.bak' because it is being used by another process.
9/1/2011 7:17:03 PM Cleaning E:\Mirror_Data
This is all running on the local server
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
This may happen because of insufficient rights. Also I'd like to ask you to install the latest version (6.1.6) that we may test the same version with you.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/5/2011
Posts: 9
|
I have installed the latest version.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/5/2011
Posts: 9
|
I resolved my permissions problem be deleting all my jobs and recreating them all from scratch. I suspect that something corrupt with respect to credentials is getting stored in your application. You might want to look at how you are storing credentials.
Now, I am still receiving these types of errors:
9/8/2011 8:15:04 AM Creating backup of PF Database SQL to E:\Temp_BU (differential)
9/8/2011 8:15:07 AM Backup of PF Database SQL completed
9/8/2011 8:15:07 AM Zipping E:\Temp_BU\PF_Database_SQL201109080815diff.bak to E:\Temp_BU\PF_Database_SQL201109080815diff.zip 9/8/2011 8:15:08 AM ERROR: Zip failed: The file item could not be opened for reading.Type: Xceed.FileSystem.DiskFile
FullName: E:\Temp_BU\PF_Database_SQL201109080815diff.bak
9/8/2011 8:15:08 AM Removing the backup: E:\Temp_BU\PF_Database_SQL201109080815diff.bak
9/8/2011 8:15:08 AM ERROR: Removing failed: The process cannot access the file 'E:\Temp_BU\PF_Database_SQL201109080815diff.bak' because it is being used by another process.9/8/2011 8:15:08 AM Removing PF_Database_SQL201109080815diff.zip from E:\Temp_BU
9/8/2011 8:15:08 AM Cleaning \\H3-backup\Mirror_BU
This exact same job runs every hour, runs sometimes without error and sometime with error. It is almost as if under certain situations, the job is trying to zip the backup before the backup is written and then gets an "opne file" error. Is there a fix for this?
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
Give us a few days to research please
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
It seems that some program (like antivirus or indexer) blocks a newly created .bak file so it can't be opened for reading right away and even after 1 minute it still can't be removed (judging by your log). The fact that it happens from time to time proves that it's something relating to your system configuration (not SBF). I'd happy to help you here but I really think that you need to find a program blocking the backup file. For example let it be created and then see what blocks it using tools from http://windowsxp.mvps.org/processlock.htm.
|
|
|
|
|
