If I decide to run a DBCC DBREINDEX job in the future (from inside Query Analyzer I assume?) do I have to put the DB in Single User mode before I do so?
as Gail said, no, but it is an intrusive process that will block user queries so be careful when you run it, best to leave it to your out of hours maintenance plan.
....and you dont need to buy any tools for any of this stuff
Thanks so much to you and to Gail for all the helpful info. It really helps.
I've been trying to locate a performance hit that's been slowing down my users during the translog backups and I think I've found the cause. On the Integrity tab of the plan, "Check database integrity" and "Include indexes" are checked *along with* "Perform tests before backing up the db or translog". Looking at the translog backup log I can see that it takes about 4 min for this DB check to run. So is there a way to have the integrity check run only for the DB and not the translog backups? Or should I create separate plans for each so I can avoid the 4-minute drag on resources?
Maybe the simplest thing to do is just to Uncheck "Perform these tests..." and have the checks run only with the weekly reindex job?
Sorry for the long post. Hope it makes sense.
Thanks.