How to Change Reuse wait reason to Nothing from LOG_BACKUP

[chandrababu_katta]

Anybody tell me How to Change Reuse wait reason to Nothing from LOG_BACKUP

OS: MSSQL Server

DB:SQLSERVER

SAP Version: ERP6ehp6

[chandrababu_katta · Accepted solution]

problem solved by taking Full DB backup and then Transaction Log Backup.

After that Shrink the Log file and change the mode to FULL by using

ALTER DATABASE [DBNAME] SET RECOVERY FULL

Now the Log_reuse_wait_reason -> chamged to NOTHING

[Sriram2009]

Hi Katta

In MS Sql DB once the daily backup operations completed then you have to perform the MS Sql Log DB truncate backup for that kindly follow the SAP Notes

1297986 - Backup and Restore strategy for MS SQL Server

1420452 - FAQ: Restore and recovery with MS SQL Server

Regards

Ram

[chandrababu_katta]

Thanks Sriram,

Actually i'm trying to change the Reuse_wait_reason under Log to Nothing as shown in below figure

could u tell me how to change it.

[Sriram2009]

Hi Katta

when you are performing the Log backup (Truncate or No Truncate backup) it will change the status to " Log Backup" after completes then it will change the status to " Nothing" .

Regards

Sriram