parminder.parmindersingh (2/8/2013)
But if i restart the server or SQL services all recovery will undo. Then what is benefit of restart Server?
Currently the schedulers are hung. If all of them are, then no work is happening. Restarting might get recovery to proceed normally (or the schedulers might hang again)
Might be worth calling MS support and opening a case with them
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