I am trying to understand the need to run DBCC checkDB. We have set up maintenance plan to reindex and check the integrity of DB weekly. Every thing works fine....

Thank you for all. It is very helpfull.

I set up backup job via maintenace wizard in sql 2005. but my old backup can't be erased even I select overwrite...

Thanks. It make sense.

one more question, when you do weekly system DB backup. do you also backup transaction log? how often it need be?

The problem was solved.

The application which accesses to SQL has a module to check the data constantly. After it was changed to connect to sql every 10 second. see...

Hi, Kevin. Thanks you for the response.

Could you give me more detail information on the reason you listed here?

In the our VM enviroment, 2 SQL servers share the same blade....