When ever you find that the data base is in suspect mode use the below script.

Exec Sp_resetstatus ‘Yourdbname’

Alter database yourdbname set emergency

Dbcc checkdb(yourdbname)

Alter database yourdbname set single_user with rollback immediate

Dbcc...

Hi dude when the transactions will happens automatically the log size will grow,so on the time there is an option to shrink the log file,below are the command executed in...