• Dbcc checkdb is checks the integrity of the database why you want to do every 2 weeks

    and it also a resource intensive .

    usually you have to do dbcc checkdb when you set your databse to single user mode.

    there is chances of failing job due to concurrency with other transactions parallely.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]