If you do Just a select with a where clause of one of the values that you know should not have duplicates. Do you get more than one record?

Are you positive that they are duplicates if any of the columns have anything different leading or falling zeros, spaces could make sql server see the row as unique.

Why don't you just download SQL Server Express to get your hands dirty first before spending $$.

http://www.microsoft.com/express/Database/InstallOptions.aspx

They are right it is much easier to manage your system in full recovery model. If your wanting to keep your hands out as much as possible you can do...

Hey appreciate that sometimes all you need is a second pair of eyes!

rfr.ferrari

No problem on performance this is for High availiability being able to recover with low or no loss of work time. In the case of hardware failure active/active failover in...

Thanks, Elliott!

WayneS or SQLRNNR

Not sure of that, But I read the licensing agreement from Microsoft and they consider it to be part of a failover cluster in my case of active/active...

Thanks for all of your replies! I have my answer: Active/Active would be necessary for my clustering needs.

WayneS

So your saying if I did a 2 node failover and did log shipping that would be considered a 3 node cluster by microsoft?

WayneS

Thanks, I was trying to set up where I have 3 sql servers on standard edition so that I have a failover and can log shipfrom node 2 with out...

Elliott

With that said if node one is active and node two is active and node 2 is the fail over can I use the node 2 for log shipping...

WayneS

So if active/active does not have the same resource how is the sql server able to failover with ur copy of production db?

Hey GSquared

I thought spreading out the work load is called load balancing and SQL server does not support true load balancing?

Thanks LutzM thats what I was looking for.