on 12-24-2013 6:11 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.