Thank you - that worked.

The correct syntax is

sp_trace_setstatus [ @traceid = ] trace_id , [ @status = ] status

Thanks for the suggestion. I had not heard of this utility, I will research it.

Thanks

Thanks for your replies.

The disk on the new servers are part of the server - not on a SAN. The current configuration has them on a SAN.

I'll try monitoring with...

You are so correct in there being no downtime. We will pick a time of day to minimize the impact to potential connections.

Sounds like log shipping is the easiest solution...

I've found this tool very helpful, in automating too many tasks, we've been doing manually or with a combination of tools. Having everything in one place is wonderful.

We also have...

Very thought provoking article. I also appreciate the the Microsoft links - I will follow up on them.

I usually enforce encryption in my SQL instances for my network connections, since...

Thanks everyone.

Gail's article was especially helpful.

I understand where you're going with these steps. Getting the window to do this on a prod server isn't always easy.

When I failed-over from Node B to A, the instance...

In trying to repair or remove the node, I'm using the SQL Setup -> Maintenance options on the CD.

I configured the node to not automatically failover. Then I moved the instance from Node B to Node A. When SQL was in a failed state on Node A I...

Thanks for your replies. They are helpful.

Correcting the Select statement to populate the variables was the trick.

The information in the temp tables isn't sensitive, and I drop them at the...

Thanks.

I'll see how that goes.

Based on information I found in Gila Monster's initial respone - I followed the link to blogs.msdn..... 'Size of the Transaction Log Increasing and cannot be truncated or Shrinked due...

Error: Invalid column name 'originator_id'. (Microsot SQL Server, Error: 207)

Yes I am familiar with the log file structure. The good new is that my log backups are permitting some of the entries from being deleted & the space being...