I'm afraid, without a third party tool to log the connections you wont be able to as far as I'm aware

Sapen (10/27/2011)

---

How do i know if the updates are going to have a good/bad impact on my database server? What is the correct way of identifying which updates are necessary...

I don't install SSIS on clusters as its not recommended and isnt cluster aware. Have you read this article?

http://msdn.microsoft.com/en-us/library/ms345193.aspx

jared-709193 (10/27/2011)

---

Scenario:

Application may be routed to 1 of 4 servers depending on load and location: Colorado, Michigan, 2 Illinois. Data from each server needs to be replicated to 1 reporting...

No problem! 😀

Greg Snidow (10/27/2011)

---

Thanks to both of you for such a quick response. In searching BOL for an answer, I quickly realized there is much opportunity for me to learn...

You are free to delete .bak files as you please. They are not involved the actual running of SQL Server itself and wont prevent it starting up.

I would suggest...

Lexa (10/27/2011)

---

It's configured Weekly, Mon-Fri, begin 8 AM, end 7 AM, run every 3 hours. Not sure why you cannot have schedule which spans days, since the option is...

How have you configured the schedule?

You cannot have schedules which span days.

Also, if you want 8am – 7am your schedule will begin at 8am Monday and finish at...

I've never patched a mirrored server but the same process applies as...

I can confirm its NOT a powershell issue. I can manage all of my servers through powershell in some form, although Im sometimes restricted in the method when remoting...

ChrisM@Work (10/26/2011)

---

I've had two HTC phones, the XDA and the XDA IIs. Both performed really well...

Gianluca Sartori (10/26/2011)

---

I agree that shrinking tempdb may not be is not a good idea.

However, you could try to issue DBCC FREESYSTEMCACHE('All') before shrinking. This flushes the system cache, including...

For whats its worth, I still enable this setting.

This article from the SQLCAT team recommends this as part of their benchmarking.

http://sqlcat.com/sqlcat/b/technicalnotes/archive/2011/04/26/lessons-learned-from-benchmarking-a-tier-1-core-banking-isv-solution-temenos-t24.aspx

You dont need to restore master. I do this on a fairly regular basis.

you need to run sp_subscription_cleanup