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 1 year, 1 month 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...

If you search for interview questions for DBAs, you'll find a wealth of questions.  I also want you to be aware that, while the questions can be pretty good,...

i donot want destop and neither i am continously going to run sql server .Also sql server would be running mostly within VM only.I have different doubt question  laptop manufacture...

T-sql/sql programming is weak points of mine between should  is do azure certifications for future or at present certifications related to 2016 would do ?? as i have heard that...

The 4000 series Ryzen CPUs seem to be great value in terms of performance/power.  H-series are competitive with desktop chips for performance. U-series have more moderate performance, and are...

I don't know of anything beyond senior DBA. You can certainly switch roles to something else, and some people move to be managers or architects, but the progression isn't...