December 10, 2003 at 2:33 pm
Greetings. Each day a backup appears to be run against my database but it is not part of a maintenance plan nor did I schedule it. I am unable to determine how this backup is being run. Is there a way to determine what is firing this off?
Thanks.
December 10, 2003 at 5:24 pm
Got to some job that is running it. Could be a job running from somenoe's desk as well (scheduled tasks). Run a trace (profile ) for that time and see what you get.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 10, 2003 at 7:13 pm
Steve, it turns out that at some point I created it by hitting the tools -> backup database menu. Now I would like to diabel/delete this backup plan but am unable to determine how to do that. I scheduled it and unchecked the enabled box but am looking for a way to get rid of it completely. ANy suggestions appreciated. Thanks.
December 11, 2003 at 1:41 am
to see this job :
go to EM (Enterprise Manager) , expand your server , expand "Management" folder, expand "SQL Server Agent" , click on "Jobs" ...
here you will see all jobs .. by double click on a job .. and go to "Steps" tab .. to know what the job do ...
then when you know the job you want to delete .. right click on it, and choose "Delete" or "Disable Job" >> so it will not work again
I hope this help u
Alamir Mohamed
Alamir Mohamed
Alamir_mohamed@yahoo.com
December 11, 2003 at 10:18 am
Alamir's advice should work for you.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 11, 2003 at 11:03 am
Thank you both. I was able to delete the job.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply