Видео

Are you working with CZ recovery services?

Thanks for the explanation. What about licensing VMware ESXi hosts? Suppose you have 2 ESXi hosts that you will license with SQL Enterprise. You can put a number of VM's on it. We setup SQL"s with AG primary/secondary. If you intend to use the second ESXi host as a "passive host" (serving all secondaries). Do you need to license the TWO hosts or only the host what is running the VM's that are a primary node of the AG? Thank you!

Hi Edwin, nice and clear demo. Thank you. So since your AG1 and AG2 have a different DNS record for the listener, your applications will still need a small config change in their connectionstring. The best thing I can come up with for this is using a CNAME record in the connection string, pointing to the old AG1 listener. Your applications can adapt this connectionstring change whenever you want in forehand. Then on doing the DAG failover, just changing the CNAME record to point to the AG2 listener (with a small TTL already set). That's for the part of being independent of your application developers and having minimal downtime. So, there "IS" actual a little downtime on failover. Are you aware of an even better way? Bringing the AG2 db's out of recovery mode will ofcourse require some downtime on rollup. Can you drop the DAG afterwards using the DROP AVAILABILITY GROUP statement on the DAG? No further action required? Thank you!

Thank You very much

I'd like to express deepest gratitude to you, Edwin, for dedicating your time to prepare these series. Incredibly helpful, incredibly enriching.

Dear Edwin, we truly appreciate the effort you have put into creating this material. It's certainly very helpful.

Very informative , thanks for your effort to make this video's

The article and the video use different server names. very confusing

This is realy great! Just a tip if You try to setup this in Oracle Virtual Box: Uninstall the Utilitys (on ALL Nodes and the DC, otherwise You'll face Errors like (Network address is invalid or Access is denied").

@EdwinMSarmiento, I'm trying to install the SQL failover cluster and am getting the error below. can you please help? 2024-11-15 09:22:05.574 E SQL Server 2022 transmits information about your installation experience, as well as other usage and performance data, to Microsoft to help improve the product. To learn more about SQL Server 2022 data processing and privacy controls, please see the Privacy Statement. Notice: A paid SQL Server edition product key has been provided for the current action - Standard. Please ensure you are entitled to this SQL Server edition with proper licensing in place for the product key (edition) supplied. The following error occurred: The state of your SQL Server installation was not changed after the setup execution. Please review the summary.txt logs for further details. Error result: -2068643838 Result facility code: 1203 Result error code: 2 Please review the summary.txt log for further details Microsoft (R) SQL Server 2022 16.00.1000.06

Best trainer. I used your Cluster videos to retrain myself.

Clearly explained! Great job!

Hi Edwin, just a remark to this great presentation, at +- 20 minutes you're bringing online the harddisks and initialized them as MBR. For drives not required to boot from it is adviced to initialize as GPT as these drives can serve volumes larger than 2TB. MBR cannot go beyond that limitation.

Very good and clear presentation. I'm sure this is an added value for beginners.

I can consider myself expert now 😎🤣

Not able to Download the Cluster Preparation Checklist. No email has been received. Can you send me the working link?

where are the four storage drive came from? Is it shared or its from the internal HDD?

Thanks and Grateful to you. I have a question, the MSSQL has been installed as Failover over Windows Cluster. Now I have an web application(IIS and Apache based), do i have to also install it on both node and how can i add them in Cluster role?

Really Awesome. Grateful to you

which udemy course included this training pls?

Did this in 1999 Advanced Server 2000 and SQL7 clustering, BLAST from the PAST

just in time. I needed this info and it was 2 weeks ago! Subbed now :) Need to watch more of your videos.

what happens to the tlogs if the replica is offline? does it grow forever ?

Bro im becoming your fans , this tutor really helpful , subscribed and please do another good job again for sql server 🎉🎉🎉

hi. you mentioned providing a link to the cluster preparation checklist spreadsheet?

Can SQL cluster work on a workgroup environment instead of an Active Directory environment? Thank you. Btw, cannot find the link to download the checklist, thank you.

Can CUs be applied by just pausing a node and draining the roles and vice versa?

Love the incredible detail you provide. Thanks for taking the time to share this with us!

Thanks for taking the time to go through each step! Extremely helpful for me! I'm going through a two-node cluster setup.

Pls make video on always on high availability also.

i see is a pretty old video, but i have a question.... why use dns and not edit a hosts file ? i wll have less dependency ... you depend from DNS in this way.... is still the same with 2022 ?

Found this from a post from Erik Darling. A bit late yet great discovery

This video deserves all the awards.

please release the audio format in Google Podcasts & other audio channels.

Don't stop. You have a quality cintent

Thanks for you , Really Nice

'Promosm'

please release the audio format in below podcasts channels as it helps listening while commuting/working. thanks

Thanks for sharing 💯

- all questions are based on: a. Stand Alone Servers b. No shared storage c. All are on the same subnet (except for DR) 1. How would you do HA & DR for SQL 2019/2022 in docker containers, and have AlwaysOn AG /w Listener? 2. Can you have HA & DR on 2/3 Windows Server 2022 Core + SQL Server 2022, With AlwaysOn AG /w Listener? 3. Can you have HA with just SQL Server 2022 docker containers with AlwaysOn AG /w Listeners? 4. How do you do failover for HA & DR on SQL Server 2022 in docker with ALwaysOn AG /w Listener? Please & Thanks.

🤣 *Promosm*

Great work. Thank you.

Excellent explanation. A teacher at work!

So true, you are spot on.

I have one question. We have 3 nodes configured, 2 of which are in the primary datacenter and 1 in the disaster recovery datacenter. All of the systems are set up with Windows 2019 and SQL 2019, and the primary datacenter's DB is configured with synchronous data transfer while the DR is configured with asynchronous data transfer. My issue is: Should we use Azure storage or where can we put the Witness server?

Thanks

This is the hammer in the right nail. I really appreciate your inside on this subject. I hate the idea of joining Hyper-V host to a Domain. I have been looking for a solution to this. I know I will loose some Hyper-V functionality like VM Replicas and Live Migration. But that's is an acceptable lost to me because I haven't had the need for either so far after 10 years using hyper-v.

Edwin this video is SHOW, congratulations about this technical profile and experience with SQL Server FC

I still don’t understand why someone have synchronous node on DR site or different data centre having different subnet , what do you recon Edwin, why it would be a case ? What advantage or disadvantage we could have

do you have a Database mirroring tutorial?