SQL Server 2008 Standard/Enterprise/Developer edition install Media with Service pack 2.
One IP address as SQL Cluster virtual IP and host-name as SQL Cluster virtual host-name. Our clients will have to use this host-name or IP to connect with this fail-over instance.
One shared disk to place all our System DB files + error-logs etc
Minimum two identical clustered Windows 2008 Servers.
… Will be adding more. Couldn’t remember all of them at one shot. Please add any missed out points below as comments. Thanks in advance.
Method
Log-in to any one node and move all the cluster resources to that node.
Navigate to the media directory and execute the below command. This is to make sure we don’t move all the SQL server binary files into C drive.
setup.exe /ACTION=INSTALLFAILOVERCLUSTER /INSTALLSHAREDDIR=”J:\Program Files\Microsoft SQL Server” /INSTALLSHAREDWOWDIR=”J:\Program Files (x86)\Microsoft SQL Server”.
Technology enthusiast Sherbaz is a Microsoft certified SQL Server Subject Matter Expert. He had fun automating day to day task to achieve management goals. He has extensive hands-on experience in high availability deployments and support with several years of industry experience performing SQL Server installations, configuration, maintenance, backups, performance tuning, Transactional & P2P replication, migration, high availability solutions (Always on, Failover Clustering, Logshipping and Mirroring) and Disaster recovery.
Sherbaz also has basic hands-on experience in other DBMSs like MongoDB, Oracle 9i, 10g, Sybase and MySQL. 1 year on Mongodb, Oracle 9i & 10g. Completed M102 & M202 courses in MongoDB.
Sherbaz spends his spare time with automation in electronics, embedded system circuits and IOT in his private lab at home.
Also, he supports his customers and users at www.SplitExpense.in for issues with app, website or telegram chat bot @SplitExpenseBot https://t.me/SplitExpenseBot. @TheSherBot https://t.me/TheSherBot is another telegram chat bot, partially artificial intelligent, programmed and maintained by him on python and backend Mongodb database.
Sherbaz always showed interest learning new technologies and to think out of the box bringing innovation in work. Some of his work is documented @ www.sherbaz.com.
He is now busy learning 3D modeling software on his roadmap towards building his next hobby build, A 3D PRINTER.
Subscribe to his youtube channel
https://www.youtube.com/c/SherbazMohamed/
View all posts by Sherbaz
