suppose my database is just corrupted after running command backup log with NO_log , how Will I restore my databse?
Restore your last full backup and any transaction log backups that you do have. Same way you restore any other time. Since that command breaks the log chain, you won't be able to take a tail-log backup and so the best you'll be able to restore to is the last transaction log backup that you had taken.
You shouldn't need to run that command. If you want to auto-truncate the log, switch the database to simple recovery model. Then sort out the large log file, switch the database back to full recovery, take a full backup and set up log backups.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass