Great. Curious how you implemented that? Would that fall into big project?

On a side note, the Microsoft SQL Server database role SQLAgentUserRole apparently lets a member create/delete SQL Agent jobs...

Thanks i got the solution.

My understanding is that when the cluster is created it will create the new DNS entries when we create listener . So they register themselves right rather them manually in...

Sorry about that. Just making sure. You mentioned about telemetry services would that really work?

Sensitive data should absolutely not be in use in dev & test servers that means the data needs to me masked in dev?

I tried configuring the AG without WSFC. However, when i tried to do a manual fail over and i see that there is a option grayed out. Does that mean...

This is what i can think of, Usage will be restricted. There is a risk of side effects using SQL Server 2019 Developer Edition instead of the real edition for...

Since  SQL Server 2017 doesn't  require WSFC for AlwaysOn AGs. So i am thinking to configure AG without WSFC. Do you see any issues with this? Does it matter if...

Have you seen any issues with AG while configuring or managing with few databases Vs 33 databases?

Thanks Jeffrey! Node4 will not have any other user databases other than reporting DB which would be configured with AG. In case if there is any server issue or corrupted...

You're right Michael. Seems like someone is trying to put unrelated question. Thanks for suggesting him to to open a new thread.

The question i have is For Node4, which will...

For Node4, which will be used for reporting purpose only, i am thinking it does not need any snapshots taken at the drive level and also backups of drive is...

Yes. However, i did not made up mind yet to use AGs. The major concern I have is that the server has two many databases(approx 20 - 30db) to configure...

In an event of disaster i think the data loss would more using log shipping when it compared to Always on AG group. Unless you schedule more frequent log backups.

I agree. But this is an old fashioned DR Solution right? Is there any benefits of Log shipping over Always on AG?