Jeffrey Williams (4/24/2009)
sharanurampur (4/24/2009)
Dear Friends,I too don't know the exact problem, what I am predicting is we are having 2 instances and I stoped one instance completely(Dissable), and restared service agent 3-4 times, and after i have refreshed DB then it has come. I think it may be conflicting in the 2 instances.
Thanks
Sharanu.
That is why we have asked multiple times for the system configuration (e.g. Memory, number of instances, etc...).
It's also why we've asked multiple times for errors from the error log so that we can identify the root cause for you.
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