July 27, 2009 at 9:32 am
Can Optimization and Integrity job run at the same time?
July 27, 2009 at 12:21 pm
Integrity job - Reorganizes index , optimization - rebuild index , its advisable not to run both jobs at same time , its worth putting as a single maintenace plan to run integrity first and optimization second vice versa , not good enough to run at same time
July 27, 2009 at 8:20 pm
If you are using the Maintenance Plans in SQL Server I also would recommend scheduling the Integrity Checks to occur before a full database backup. This aids in ensuring the database is in a consistent state prior to backup. Of course verify your backups from time-to-time as well goes without saying.
- Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply