Brandie Tarvin (12/21/2011)
Gail,I think I just found something. Read Jag's post here: http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/71d3cd0b-ce4d-4202-8e3b-38b38da90a5b%5B/url%5D. It sort of makes sense to me, but I'm wondering what else could be affected if I take this advice.
Not sure if that's applicable? Are the jobs just jobs or are they maintenance plans? If they're just jobs, there isn't an OS process involved.
EDIT: I can't restart SQL. This is a production box.
Just SQL, not the server. If that is the issue I had, you won't be able to take any full backups (or diff) until you restart SQL. See if you can schedule 5 min down soon (doesn't have to be now)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability