Query u have given is not working...

and backup of transaction log is going on twice in a day..

anything else u want.