Good morning Just to divert the conversation in a more positive direction we are using Azure for a couple of large clients websites which have the potential of growing quite large. I know another local company which also using Azure wholly for their client for mission critical solutions as well (if they did not work people would die). One of the reasons we used Azure for one of our sites is the capacity / room to grow. We have our own server farm however this site is a video sharing / social site and potentially could have thousands of videos (if not more) being uploaded by servers. Storage/bandwidth etc is not a worry with Azure and cheaper than us hosting / streaming also. Azure is a great platform, but does not suit all companies/applications. Concerns with data security which have been raised are normally more the normal scaremongering which always get raised in the cloud. Additional security can always be put in yourself if you are really that concerned so even MS would not have access to the actual data. Shane
Member 2599525
Posts
-
Cloudy with a chance of Development -
SQL High AvailabiltyAll, Just looking for peoples advice based on experience with sql high availability. Basically in the past we have used SQL Clustering without any issues for high availability, I have used this in many companies how ever we are currently moving environements which I will not have the option to use clustering. So basic setup, two sql servers (active/passive roles) running SQL 2008 standard, database files are stored on a high speed SAN. So need some options, I know I can use log shipping, however failure time is >1min. Also for patching how do I restart a server and ensure the other server which is being logged shipped to has the latest data ? Mirroring is a option, however according to MS mirroring should not be used on more than 10 databases. We have lots more! The last option which seems bad practice but could work is simply kill all users, detach db's and then reattach to other server. Any issues with this ? Ignore any issue with client connectivity based on server names, this can be resolved in different ways. Any real advice appreciated, I have read most of the SQL documentation so no need to just forward me to there :) Thanks Shane