August 22, 2002 at 10:29 am
A job was configured to execute a DBCC defragmentation SP against a local database. Instead the job ran the DBCC SP on a different server. The server where it was suppose to run is the backup server and the server where it did run is the production server so they each contain the same database.
Relevant facts:
The SP does not have any server references.
The job does not exist on the production server but the SP does.
The command in the job step has no parameters, just the SP.
The backup server is not set up as a MultiServer MSX.
The backup server does not have the production server as a Linked Server.
The production server is set up as a Remote Server on the backup server.
I am wondering how this happened and actually did run against the backup server as well.
How did the job run against the production server?
Is there a way to determine the defrag history of a table?
Thanks
Ron
August 23, 2002 at 3:46 am
Did you check your job for possiblity of reference to remote server. Also to root it out using Profiler on Backup server and one on Prod server force the job to start and see what shows up. You can see the source ofthe call in Profiler. If does indeed run on Prod and not on Backup then either the job has a reference or the sp, but I believe the Backup profiler should show the call made. If does not show up when you run then you may have a job or other process on the Production server you are forgetting about. Also, if is part of a DTS package per chance double check what connection you are using. Finally, drop the sp and job and rebuild on the Backup server and test again if all else fails.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 23, 2002 at 5:36 am
How do you know this is what happened??
Andy
August 23, 2002 at 9:01 am
Thanks for the responses. I know it ran on the production server because when I looked at its Current Activity there was a process running a DBCC and the host was the backup server. At the same time the job was executing on the backup server.
August 24, 2002 at 4:46 pm
Again profiler should pinpoint where they originated from exactly.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply