.. is it SQL Server 2008 cluster ?

I think you can open "cluadmin.msc" and take it offline...

..Whats the current size of the tempdb in MB ..?

And how much MB are you trying to shrink it to ?...

.. Can you try attaching it and drop it ? Just my thinking... Other experts might guide you..

Thanks Gila..

Any scripts or link where I can get the details... ?

Thanks again.

s_osborne2 (6/20/2013)

---

Hi,

You need to look at the log files in the following directory:

C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

(Assuming you're running 2008R2) Your directory may differ slightly. When the service starts or...

Thank you all.

Just one more query..

What are thr things that we need to do to speed up the index rebuild process ?..... in brief...

Thanks again.

Thank you all. That clarifies. Let me check what's available there.

homebrew01 (6/1/2013)

---

I have a default trace running 24/7 that I can use to troubleshoot. You could set one up for the future. Then look at activity in the timeframe between...

Gila,

Thanks for the quick response...

It's for rebuilding the indexes.. nothing else..

Smith.

.. Is the problem solved ?

..Thanks Gila... No it happened yesterday only. Can you please guide me how to go about it now.

Since it's very urgent, googling will take time.

Thanks again.

Hello Steve,

Thanks a lot. Yes, was looking for something like that. Covers one by one and not as vast as BOL.

..Thanks. However any free material to download ? 😀

Hello,

Thanks for the quick response.

It's not for any particular replication but overall. Have somewhat fair idea about replication configuration and have worked on it in the past. Want to...

Do you mean RESTART ing SQL will solve the issue ? No, it...