0
votes
0answers
56 views

SQL2008 R2 BackupDirectory - Cannot access the specified path or file on the server

I've recently added extra SAN storage space to our SQL2008R2 server (Failover Cluster with 2 nodes). With that I've edited the follow registry entry from I: to K: and moved the existing backup folders ...
2
votes
1answer
106 views

SQL Server 2008 R2 Failover Clusters behaviour on multiple failures

I'm testing the resilience of one of our test systems. We have 2 x DB (SQL 2008 R2 on Server 2008 R2, running in ESXi VMs) arranged in a Failover Cluster. Shutting down the Active SQL Server service ...
1
vote
1answer
339 views

Clustering MSDTC on windows Server 2008 R2 returns “No storage Available”

I've set up a failover cluster, with SQL Server 2008r2, and it is running fine. I want to cluster MSDTC as well, but when I go through the high availability wizard, it tells me that there is no ...
1
vote
1answer
2k views

Quorum Disk size for Windows 2008R2 failover

I am setting up a two node failover cluster for SQL Server 2008 R2 on Windows Server 2008 R2. Microsoft recommends minimum 512MB size LUN for the quorum disk and don't have a recommendation for the ...
1
vote
3answers
2k views

SQL Server 2008 R2 Clustering inside VMware

I am working on a new Windows 2008 R2 / SQL Server R2 HA cluster and we are planning on running this inside of VMware ESX 5. I have read and heard differing views on using SQL clustering inside of ...
0
votes
0answers
184 views

Windows 2008 SQL cluster won't come online after db failure

We have a new SQL 2008 R2 cluster on Windows 2008 R2 that is active/passive. We restored the large db to the sql instance to start testing and it choked on the integrity check and failed the db ...
0
votes
1answer
342 views

SQL 2008 R2 Active/Active/Passive Cluster Does Not Allow Linked Servers Both Ways

We are designing an active/active/passive failover cluster using SQL 2008 R2. We have two separate instances of SQL 2008: instance A is on node 1, and instance B is on node 2. Right now I'm trying ...
0
votes
2answers
1k views

Clustered MSDTC - No transaction is active

Hi I Currently have two clusters (W2K8R2) with SQL 2K8R2, both with MSDTC cluster service enabled. I've configured the MSDTC with all checkboxes, and Incoming Caller Authentication Required and NT ...