Thank you Mr. Eirikur's and Gail.. I resolved LDF file corruption problem and database working as expected. I followed Mr. Eirikur's steps and slightly changed..
1. Stop SQL services
2. Copy the...

Ok..I will follow Mr. Eirikur's suggestions.
I have doubt.. How TLOG backup successed till time if LDF file got corrupted. I think some of the log block was issues.  

CHECKDB command output no errors.

CHECKDB found 0 allocation errors and 0 consistency errors in database 'JMDBIOMET'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

During database backup Error message record in error log file.

Message
Error: 3041, Severity: 16, State: 1.
Backup detected log corruption in database JMDBIOMET. Context is FirstSector. LogFile: 2...

3. Database to changed FULL recovery mode from SIMPLE

then try to take FULL backup again. but this full backup not successes again same error

Hello Perry,
Combination of windows 2016 and SQL 2016 alwayson HA feature can support windows cluster multi subnet failover in workgroup environments, So in this setup where windows cluster object and...

Thanks Mr. Perry.
I have gone through Microsoft Link and documents which is suggested by you.
In that architecture backup share server introduced and this backup share folder storing TLOG backup files which...

Thank you Mr. Perry and Mr. Anthony. for yours valuable comments
I will disable custom TLOG backup in Principal database server during configuration of log shipping.
Does Log shipping...

Hi jigging.tech, Thanks for reply..

One of the OLTP database recently configured AG setup in SITE A (Primary datacenter). the same database will going to extent for DR setup at SITE...

The same error repeated after removed quotes on both side..

@query = 'select logdate, procInfo, ERRORLOG from tempdb.dbo.ErrorLog where Id >= (select TOP 1 Id from tempdb.dbo.ErrorLog WHERE ERRORLOG Like ''%Deadlock...

Thanks Tony for your reply, I have tried and modified on existing script for file attachment as below, but its throwing errors

Please help.

declare @subject varchar(250)

select @subject = 'Deadlock reported on...

Hi.. it is very useful script for monitoring deadlock event occur in OLTP databases.

I am facing same issues: But when deadlock occurred i received attachment in text file but...

Hi,

I would like share the AG setup.

I recently deployed alwayson availability group one of the OLTP database for DR requirment with MultiSubNet failover.

OS: Win 2012 R2 standard edition, DB: SQL...

Hi SQL GURU and Jeff,

Issues resolved by developer, he has changed and modified the existing whole query at application side. After that there is no glitch and blocking...