Originally posted by: ebaycj
Correction.
It will be fine IF IT IS NOT IN A CLUSTER.
It WILL DEFINITELY cause problems if it is in a clustered environment and you kill all network connectivity to the cluster. Trust me, This has happened to me before. Stupid networking people.
Also, it really depends on your applications as to whether there will be any data level corruption or not.
SQL Server itself should be fine, Correctly designed applications should be fine. Badly designed (home grown, usually) applications might not be fine.
What may happen is that if the application does not correctly "bundle" its SQL work units into SQL transactions, they may be partially committed when the network connection cuts (data in one table but not in another, when data is always expected in both, for example).
This would lead to SQL being fine and not showing any errors, but your application would likely have problems, maybe even sporadic problems, depending on how things are designed.
Facebook
Twitter