LOOKUP_BI-756009 (8/2/2011)

---

Is there any other solution that I can try before restarting the service, as I have may more application database on this server ?

Any idea why this sould have...

Andrew L. Smith-213145 (8/2/2011)

---

SSCoach:

In some instances, the job hang was not discovered for 2 or more days. The job/plan will hang indefinately at the restore headeronly step until it is...

... none to give but I'm listening in.

Nice script > briefcasing!.

Had you considered the profiler method to see what was going on? Might have saved you some time.

afraid to ask...

and nothing else?

Couldn't it be that it's waiting a lot on IO to complete the rollback?

Did you try contacting the vendor? "Might" have better luck for a fast answer.

jez.lisle (8/2/2011)

---

Ninja's_RGR'us (8/2/2011)

---

Sql Sentry is awesome, but you still need a .sqlplan to work with it.

Missing indexes are contained in the actual plan.

If it "only" takes 55 minutes to run...

I'm not sure we have the same definition of worked.

Either you need the left join or you don't. This filter cannot be moved around without changing the results.

[/url]

Nevermind my last comment.

There must be blocking somewhere.

What is the rollback waiting on?

--Borrowed from the activity monitor via profiler

SELECT

[Session ID] = s.session_id,

...

thirulok_t (8/2/2011)

---

Sorry some changes in the previous statement

The shrink never happened. we perform a log backup before the shrink operation.

the backup got stuck, even before the shrink operation.

I ran...

Nice catch lutz!!

Did you try this one?

No it doesn't. What you just did is converted the left join to an inner join. When you...

where dt BETWEEN DATEADD(M, -3, GETDATE()) AND GETDATE() (or use @endate if the user needs this as a parameter....