Thanks Jeff...! Let me investigate further on this issue.

Dear experts,

Thanks for showing interest in my question and sharing your knowledge to help me out.

The total drive size is about 2.5 TB out of which the "tempdb" is...

Hi Andy

Thanks for your response. I will look into the points you have mentioned.

Thanks!

Siva.

Thanks for your response.

In that kind of a situation (Availability Replica not pushing data), what should be done?

I did some further research on this issue. There was a SQL Job failed during this time frame. The failure reason was

The transaction log for database XXXX is...

Thanks so much for your time.

I also looked at your Blog. Very informative. Thanks for your service to the SQL Server community.

Did I handle it right? Or what would have been the right solution?

Thanks For your reply.

I had the log backups running every 10 minutes on the primary. But that did not help and the Log File size grew to the full...

Dear SQL Experts,

Thanks a lot for your time to answer my question.

Since I have never handled a database file over 350GB before, I was nervous and acted without consulting...

It depends. Can you explain why are you planning for a shrink?

Hi Jack.

Thanks for your reply. Let me try that.

One of my developers approached me with this query and I was not able to understand the Oracle Language.

Thanks for your help.

Thanks for looking into my question. I was not able to understand the usage of connect by statement. Let me try the answer given in the other reply.

Thanks for spending your valuable time to answer my question.

Hi,

Thanks for your reply. Yeah. I am writing my own script to have logshipping on the standard edition.

Thanks!

Siva.