Experience with FT and database?

[gbass]

Is anyone running a database on a virtual server where fault tolerance is enabled? Other then potential performance problems related to the single CPU limitation, have you experienced any issues?

[vmroyale]

Hello and welcome to the communities.

I'm running it on a Windows 2008 R2/SQL 2008 R2 with about 10 "low-volume" databases and it works great. No complaints at all.

[JagadeeshDev]

I have seen customer's have database on FT .It again depends on the performance and risk on the DB

[gbass]

I'm not really concerned with performance. A single CPU shouldn't be a limitation for our application.

What I'm concerned about is data integrity. Anyone experienced issues with data integrity due to a FT failover?

[vmroyale]

For what it's worth - I've never actually had a real failover, but I have never seen any issues reported in these communities about one either.

There is an excellent whitepaper that details the way FT works, including failover.