Query u have given is not working...
In what way is it not working?
select name, recovery_model_desc, log_reuse_wait_desc from sys.databases where name = 'myDBName'
(replace mydbname with the real name of that DB)
You are using SQL 2005? (I assume so, since this is posted in the SQL 2005 forum)
and backup of transaction log is going on twice in a day..
anything else u want.
You might consider making the log backups more frequent. If you're doing a lot of transactions, twice a day is not much.
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