Krishna1 (6/20/2013)
Sorry what i meant was "How to check active transaction?" (not log :))
DBCC OPENTRAN
Also checked the log_reuse_wait_desc (select name, recovery_model_desc, log_reuse_wait_desc,* from sys.databases where name in( ..)) it shows Log_backup for simple recovery. ( in my previou reply i have mentioned how i managed to get this description for simple recovery model)
You cannot get a log_reuse_wait_desc of LOG_BACKUP for a database that is in simple recovery unless you've just switched out of full/bulk-logged. Double-check what you ran.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability