Did you set up the linked server on SQL Server 2000 successfully?

Mattrick (11/4/2011)

---

Thanks for the question.

I am not sure I agree that the Witness is not applicable, though. According to Microsoft's documentation, you can setup a witness in High Performance...

danskisanjar (11/3/2011)

---

Does this only run if the job fails? Can you make this run when jobs also complete? On our 2005 machines we have all jobs will email on failure...

Good question, Thank you.

Please check the triggers section from this

link

You can use this query

"SELECT * FROM sys.dm_os_cluster_nodes"

As per books online, "This view returns a row for each node in the failover cluster instance configuration. If the current instance...

Thank you Steve, you have made a complex scenario simple to understand. I have saved this article in briefcase, never know when I may need it 🙂

If replication is involved, do not use detach\attach method. You would have to drop replication entirely in order to detach whereas by using 'ALTER DATABASE MODIFY FILE' option you don't...

Nice question, Thanks.

Highly informative, Thanks.

Mirroring is at the database level only unlike clustering. I guess you are already aware of this. Regarding the mirroring mode, if you are looking for automatic failover you would...

Today I was able to successfully complete all the 3 parts of this series. This was a great learning experience for me as I got the chance to build a...

Never heard of this one :laugh:

william-375754 (10/28/2011)

---

This is a great list to keep handy. One correction, most examples I've seen for mirroring use TCP 5022, and this is the port the wizard will auto...

Thanks Yusuf, very useful information, I've stored it in briefcase.