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, 4 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 2 years, 11 months 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.

 SELECT a.ServerName,a.DatabaseName,a.DatabaseSize,b.DatabaseSize,a.TrackDate as TO_DATE,a.TotalSize as TO_DATE_TOTALSIZE,b.TrackDate as FROM_DATE ,b.TotalSize as FROM_DATE_TOTALSIZE,
(a.TotalSize-b.TotalSize) AS GrowthSizeDiff_MB
FROM 
    (SELECT ServerName, DatabaseName , DatabaseSize , LogSize , TotalSize...

procedure has been created and execute that with parameter like but no values are return and history table Database_Size_Tracking records are avilable.

Exec SP_DATAGROWTH_ANANLYSIS '02-03-2020','11-03-2020','PUXKPIREP'

CREATE PROCEDURE  [dbo].[SP_DATAGROWTH_ANANLYSIS]...

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