2025-01-29 14:16:46.68 spid70 Transitioning to STANDBY

Error : 9004

Referred link

https://support.microsoft.com/en-us/topic/kb2987585-restore-log-with-standby-mode-on-an-advanced-format-disk-may-cause-a-9004-error-in-sql-server-2008-r2-or-sql-server-2012-36d6b88a-9b42-68bc-30b0-5bcf3b5293fe

• This reply was modified 2 months, 2 weeks ago by  sangameshms.

Hi Johan,

This issue has been resolved by enabling TraceFlag 3057 on secondary logshipping server and reconfiguring the logshipping for each databases,  now I can see all databases are in Standby...

• This reply was modified 2 months, 3 weeks ago by  sangameshms.

Below is the output I am getting

2025-01-29 14:16:45.26 spid70 DBCC TRACEON 3004, server process ID (SPID) 70. This is an informational message only; no user action is required.

2025-01-29 14:16:45.26 spid70...