December 10, 2003 at 10:21 pm
We have a SQLServer2000 instance which has more than 300 DB. The Integrity takes a hour or 90 minutes to finish. Several of the DBs have to be performing 24 hours a day. These applications encounters bad performance during the hour or 90 minutes.
Is there a way to seperate integrity job for several DBs within one maintenance Plan or there have to be seperate maintenance plans?
Another question, how to log DBCC CheckDB in SQL activity log. We have another server running SQL server too, but SQL Server Log folder in EM dos not show DBCC CheckDB.
Thanks!
December 15, 2003 at 8:00 am
This was removed by the editor as SPAM
December 15, 2003 at 10:57 am
Is this SQL2000? checkdb runs better with this version, but it still takes some resources. It also runs for the whole db.
you can change some options, see BOL for them.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 15, 2003 at 2:36 pm
You can put your DBCC CHECKDB commands in separate jobs one for each db you need to check.
In 2000 the complete excecution is logged on SQL log, with the message that it found any errors and who executed it.
December 16, 2003 at 12:21 pm
I beleive if your jobs are scheduled through a master server you can schedule the same job for as many databases as needed
Mike
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply