Halcyon (9/21/2010)

---

If you install Microsoft Distributed Transaction Coordinator (MS DTC) in your SQL Server group and you have other resources that are dependent on MS DTC, MS DTC will not...

AK1516 (9/21/2010)

---

hi folks,

We have planned for a two node fail over cluster where each nodes should have a instance of sql server 2008 running but with different database on...

isd83 (9/21/2010)

---

We are planning to have two clustering environment, both will be Active/Passive which would require 4 servers. Someone in our group suggested to use the same passive node to...

Run the first log backup followed immediately by another then check DBCC Loginfo

hi

what does the following return when executed against the database in question

DBCC LOGINFO

Hint: scroll down the results and check for a status of 2 near the end of the output!

Hi Jeff

results attached. I have a HP laptop with win XP SP2, 3GB RAM and AMD Turion x2 1.9ghz

query took 23 mins 21 secs

Regards

Perry

try now, the pdf is fairly large so download to disk and then open!

if you have 2 instances of sql server and 2 nodes

active\active

1 instance running on node 1, 1 instance running on node 2

active\passive

2 instances running on node 1, no sql...

try them again, they do take a while to download as they are around 4MB each

yes, to create an active active installation simply install a second failover cluster instance and move the group to a passive node!

Hi

check my guide at the following link for SQL Server 2008 on a Windows 2003 cluster

http://www.stokecs.co.uk/techdocs/Creating%20a%202%20node%20SQL%20Server%202008%20Cluster%20Configuration%20using%20Windows%202003%20MSCS.pdf

Hi

check my guide at this link using VMWare Server 2

Firstly dont use VirtualPC or Player. Use either Microsoft Virtual Server 2005 R2 SP1 or VMWare Server 2.0.x

Check my guide at this link for step by step details using VMWare...

to install a new failover cluster instance you select "new sql server failover cluster installation". For each node after that you add to the instance you select "add node to...

this is another good reason to slipstream SP1 at install time. Cures a whole load of issues with the RTM installer!