Rather than giving the agent account administrative rights to the entire server, it might help if you read this.

http://fixunix.com/veritas-net-backup/481537-start-netbackup-sqlserveragent.html

SQL Agent needs rights to create temporary ODBC connections. ...

Thanks Gail,

I've decided to go with one Witness in a separate physical location for production, and one witness for the dev/test environment.

I appreciate your responses.

Al

The only reason would be single point of failure. One witness acting as quorum over serveral production database mirroring instances are all counting on that one express edition witness...

Grant,

Thank you for going through the steps to let me know. I just posted a question to the SQL Team. Here is the post.

Let see what...

Great article, thank you for sharing.

Here is another resource. Jonathan Kehayias creates a sproc for doing errorlog scanning as well.

http://archive.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=ErrorLogMon

Here is a presentation given on performance metric...

In my experience, they would have to be on seperate LUNs, not the same LUN carved out into 2 drives. I'm somewhat SAN-challenged in my terminology, but I think...

I think you are right, I am mis-interpreting these slides. Victor talks about using them in Production, but he states the following:

“WARNING: These trace flags should be used under...

This is my final list of Trace Flags I'm going to set in my production servers, new builds.

3226 - log backups are not written to errorlog(makes for a clean log...

I found this article in which the author ran a test with 1 TempDB file. No performance gains were made.

Also found this presentation on Trace Flags, contains section on...

Found this. Could get server names in cluster, then run the last script for each node name in cluster and get the versions.

http://powershellcommunity.org/Forums/tabid/54/aft/7885/Default.aspx

Get-WmiObject sqlserviceadvancedproperty -namespace "root\Microsoft\SqlServer\ComputerManagement10" -computername...

I'm looking for more of a script where I specify the node of a cluster and it tells me what version of sql it currently sits at.

A bladelogic scan indicated one node of the server was at SP1. After I failed this test server over, I was able to see SP1. I just wondered...

Thank you everyone for contributing here.

In Summary,

1. In logical design, it cannot be viewed as a valid PK.

2. In physical design, it is valid, but only in certain circumstances such...

Windows 2008

They were not errors really, just intermittent connections issues with getting to 1 server of the 2 load balanced web servers.

I can't RDP into those servers, so I...