Search Results | SQL Server Performance Forums

Allow Table Drop - Interesting Issue

Thread by: Foyura, May 29, 2008, 2 replies, in forum: SQL Server 2005 Replication

Hi All: I have a client that wants Replication setup (SQL 2000 publisher/subscriber, SQL 2005 Remote Distributor) to replicate data to a reporting...

Node Removed from Active Server Membership

Post by: Foyura, Feb 13, 2008 in forum: SQL Server 2005 Clustering

Yes, they have McAfee on the nodes and Volume Shadow Copy is running. It was determine that Node 1 had a faulty network card. What is interesting is...

Node Removed from Active Server Membership

Thread by: Foyura, Feb 11, 2008, 3 replies, in forum: SQL Server 2005 Clustering

We have a active/passive 2 node cluster. Win Server 2003 and SQL Server 2005. Problem: Node 1 had a hardware failure. It was traced back to faulty...

Remove Failed Node

Thread by: Foyura, Feb 3, 2008, 1 replies, in forum: SQL Server 2005 Clustering

Hello.We have an Active/Passive cluster and the Active node failed. The failed node was removed from the cluster. It was re-built and added back to...

Virtualized SQL Server 2005 Production Environment

Thread by: Foyura, Nov 29, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

Does anybody have any first-hand experience consolidating SQL Server 2005 instances onto a virtualized environment using VMWare? Historically, I have...

Mass Detach / Attach

Thread by: Foyura, Nov 7, 2007, 4 replies, in forum: SQL Server 2005 General DBA Questions

Does anybody have a script they can share that will detach all databases and then re-attach after the files have been moved to the new drive? Thanks.

Interesting High Availability Scenerio

Thread by: Foyura, Oct 16, 2007, 4 replies, in forum: SQL Server 2005 General DBA Questions

I'm on an interesting infrastructure design project at the moment. The client wants a database level HA solution with automatic failover for an...