ok thanks will check but then this would work only for standalone servers only , for sql failover cluster how can we acheieve the same

• This reply was modified 1 months ago by anoop.mig29.

any way to capture server IP

thansk for suggestions

We export this data to a central file location and then have our central inventory server pickup and process those files.

SELECT SERVERPROPERTY('ServerName') AS [ServerName]
  ...

Well folks sorry to post a reply , i suggested using open query which reduced estimated cost .But know i have know idea whether it was accepted or not.

Hi

So actual issue is  log restoration is taking time . Need to debug it.Can anybody provide pointers why ist taking time to restore log backup files

Its dedicated dr server so...

I dodnot know how did you carried out migration from 2019 to 2022 because i also tired to upgrade from older version to newer 2019 but failed to upgrade .i...

Hi

I had one query as we know by default i will create clustered index first .So wont sql server would be checking whether clustered index allready exist or not on...

We do nightly restores of two of our primary databases.

The large one is a 2TB database and has an 80GB log file with a compressed backup size of 500GB....

Most of your backups file are compressed only

As Grant noted, hardware, disk or network. You have something slowing down.

I would check the throughput you are getting, the peak reads and writes/s on the disks. Likely somewhere...

Monitoring and troubleshooting replication in SQL Server, especially in a large environment like yours with multiple subscribers and a 2TB database, can be challenging. You can check this blog...

Hi folks sorry for  reverting too late

Sorry cannt do it as size of disk on which tempdb resides is limited.Wont get permission to...

• This reply was modified 2 years, 2 months ago by anoop.mig29.

Hi jeff thanks for advice , i went by website you suggested geeks for geeks and i found it to more for programmers . .I didnt see...

I have a magic phrase I've memorized and you can have it too.

"I don't know, but here's how I'd find the answer..."

Now, you have to have a plan for...