fuzzyocelot
Programmer
I don’t know a lot about Windows servers, but I’m desperate for ideas here so please bear with me. I’m a fairly new SQL database administrator and I don’t have a lot of experience to draw on yet. Please be patient with me. 
The servers on which we have an issue are both Windows Server 2003 Enterprise Edition SP2. Both these servers are dedicated to SQL Server 2000. I tried to search for this problem under this forum but it kept returning no results. So I apologize if this has been addressed before. If it has, please refer me to the appropriate thread.
We have two visual basic scripts that transfers SQL database backup files from the production server to the disaster recover server. There are two Windows scheduled tasks that run the two scripts on a regular basis on the production server. One tasks runs every morning at 4:45 am. Let’s say it’s Task_1 that runs Script_1.vbs. The other task (Task_2) runs the script (Script_2.vbs) every 30 minutes. The production server is on a cluster but the DR server is not.
Something somewhere changed because these tasks ran fine for years. All of a sudden they stopped working. The last time they ran was on May 8 of this year. No one knew they had stopped running until I checked them around May 22 because I had noticed the databases weren’t current on the disaster recovery server. It’s a good thing I checked! No one seems to know what changed, though. Under “Scheduled Tasks”, the status just said “could not run”. When we tried to right-click and run the tasks, we didn’t get any errors and the status just said “could not run”. Both tasks are scheduled to run under a domain account called IT\SQLDR. It belongs to the Administrators group. The network guys checked and it still has all the right permissions (full control) on the domain and on the two servers (including both nodes on the cluster). So one of our network guys reset the password for this account on the domain and for both tasks. He then was able to manually run both tasks. That was the last time it ran. I checked the tasks today and the status is still at “could not run”.
I talked with our senior DBA about it and she checked a few things. She was able to successfully run Script_1.vbs as the IT\SQLDR account via the command prompt (using “run as user:IT\SQLDR cmd.exe”). She checked permissions on the destination server and everything looked fine. The destination folder is a share and hasn’t changed. She then reset the password on Task_2 and it ran fine. I then reset the password on Task_1 and it ran fine too. We’re stumped!
The Event Viewer shows NOTHING occurring at these times. No errors, no warnings, no informational messages. I checked SQL and nothing is running to cause this to happen that I can see. Our network guys don’t know what the problem is either. Something changed but I have no idea how to find it.
I’ll keep an eye on the tasks to see if they run in the morning. I’m predicting they won’t run. I just don’t know how to determine what else is running to cause this! Any ideas are greatly appreciated!!!
Thanks!!!
The servers on which we have an issue are both Windows Server 2003 Enterprise Edition SP2. Both these servers are dedicated to SQL Server 2000. I tried to search for this problem under this forum but it kept returning no results. So I apologize if this has been addressed before. If it has, please refer me to the appropriate thread.
We have two visual basic scripts that transfers SQL database backup files from the production server to the disaster recover server. There are two Windows scheduled tasks that run the two scripts on a regular basis on the production server. One tasks runs every morning at 4:45 am. Let’s say it’s Task_1 that runs Script_1.vbs. The other task (Task_2) runs the script (Script_2.vbs) every 30 minutes. The production server is on a cluster but the DR server is not.
Something somewhere changed because these tasks ran fine for years. All of a sudden they stopped working. The last time they ran was on May 8 of this year. No one knew they had stopped running until I checked them around May 22 because I had noticed the databases weren’t current on the disaster recovery server. It’s a good thing I checked! No one seems to know what changed, though. Under “Scheduled Tasks”, the status just said “could not run”. When we tried to right-click and run the tasks, we didn’t get any errors and the status just said “could not run”. Both tasks are scheduled to run under a domain account called IT\SQLDR. It belongs to the Administrators group. The network guys checked and it still has all the right permissions (full control) on the domain and on the two servers (including both nodes on the cluster). So one of our network guys reset the password for this account on the domain and for both tasks. He then was able to manually run both tasks. That was the last time it ran. I checked the tasks today and the status is still at “could not run”.
I talked with our senior DBA about it and she checked a few things. She was able to successfully run Script_1.vbs as the IT\SQLDR account via the command prompt (using “run as user:IT\SQLDR cmd.exe”). She checked permissions on the destination server and everything looked fine. The destination folder is a share and hasn’t changed. She then reset the password on Task_2 and it ran fine. I then reset the password on Task_1 and it ran fine too. We’re stumped!
The Event Viewer shows NOTHING occurring at these times. No errors, no warnings, no informational messages. I checked SQL and nothing is running to cause this to happen that I can see. Our network guys don’t know what the problem is either. Something changed but I have no idea how to find it.
I’ll keep an eye on the tasks to see if they run in the morning. I’m predicting they won’t run. I just don’t know how to determine what else is running to cause this! Any ideas are greatly appreciated!!!
Thanks!!!