Hi Ant-Green thanks for update.

Yes. AOAG setup be a subscriber to a transactional replication publication. and Subscriber receiving records at every seconds from publisher. So please suggest if any what...

Checked TLS 1.0 version , this value is 0, it was disabled in server this location - Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client

1. system DSN working by using native client 11.0 and got connected...

Hi Mr. Brian Gale. Thanks a lots for sharing link. It is working as expected and SQL server connected as expected. once again thank you..! 🙂

Step 1: SQL instance changed...

• This reply was modified 2 years, 6 months ago by  SQL Galaxy.

Hi.

Let me explain. actually SQL and OS installed from template in new host.

if new server commissioned just applied template in new host. after that assigned new host name and new...

Thank you ANT_Green.

How do we maintain SQL jobs in secondary replica? how to set jobs execute primary and secondary AG when failover/switchover two nodes.

Thanks

Hi

Thanks for your reply

windows 2016 STD edition, SQL 2016 Enterprise edition.

1. MultiSubnetFailover=True this switch already mentioned application connection string.
2.  Application using 4 .2 version dotnet version - checked with apps...

Thank you Ant-Green for your reply.

Thanks for sharing troubleshooting TEMPDB growth in database setting in RCSI.

I checked TEMPDB row versioning is 160GB but  row versioning  cleanup showing zero values always in performance monitor. checked oldest...

• This reply was modified 3 years, 1 month ago by  SQL Galaxy.

if it is same domain, DNS in another subnet , try to update new IP address at Nodes, cluster, listener objects .

Thank you Antony.

New SQL User connected to snapshot database in Mirror instance.

Thanks.

This is existing Database mirror setup.

Followed as per your suggestion.

1. Created one new user/login at Principal Instance, it is reflected to Snapshots database also in Mirror instance after create Re-Snapshot...

Existing  Users and  permission inherited at snapshots database of Source DB. Try to connect snapshot database existing user in Mirror Instance not connected.

Login failed for user 'Username'. (Microsoft SQL Server,...

Yeah, I checked that first query. some servers all available drive retrieved and some servers not retrieved. could you suggest me what kind of permission required for fetching all logical...

this code EXEC master..xp_fixeddrives retrieve only available freespace.  but total allocated size not retrieved

Yes, I got it & working now.  ) is missing.

But the above query retrieve datafile mount point only. it not fetched all available logical drive name.