Database going to Suspect mode I have a frequent problem, that is one of my databases goes to suspect mode.

Many times I have recovered it with:

ALTER DATABASE Your_Db SET EMERGENCY
DBCC checkdb('Your_Db')
ALTER DATABASE Your_Db SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('Your_Db', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE Your_Db SET MULTI_USER


It continues to become suspect after. Please provide me the permanent solution.
It continues to become suspect after. Please provide me the permanent
  solution.


The permanent solution is to figure out WHY/WHAT is causing the database to go suspect. Is it a filter drivers, bad hardware, etc. We don't know and can't tell you, this is something you'll need to inspect on your own. You'll want to get your sysadmins involved as well.


  Many times I have recovered it with: ALTER DATABASE Your_Db SET
  EMERGENCY DBCC checkdb('Your_Db') ALTER DATABASE Your_Db SET
  SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB ('Your_Db',
  REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE Your_Db SET MULTI_USER


Please, don't ever use this as the first line to attack - unless you don't like your job and are looking elsewhere for employment.

Check to see what is being corrupted, how bad it is, the extent. If you aren't sure, hire a consultant that specializes in corruption.