I am new to SQL Server Administration. I have set up the Backup jobs according to the requirements from the Application team. Also I have set tip the update stats, Reindexing Job every 2 weeks as far as the maintenance as maintenance is concerned.
I am using SQL Scripts in the SQL Agent to perform all these jobs
But i have not scheduled any Integrity Check (CheckDB ) Jobs on any of the database in any of the servers. I have databases of Size 1Gb-50 GB and few from 100-600 Gb.
I want to set up the integrity jobs on all the databases. Can you please suggest me some best ways how I can schedule jobs every 2 or 3 weeks on small databases and on big databases like 100 - 600 GB in SQL Server 2005,2008.
View Complete Post