March 31, 2003 at 9:53 am
Hi All,
Is there any convention of the order for the maintenance jobs to be run on SQL Server? Also is this specific to SQL Server Version?! (because I have got 6.5, 7.0 and 2000 as well).
Right now I am running as follows on SQL Server 2000:
01:00 AM : Optimizations Job
01:30 AM : Integrity Checks Job
02:00 AM : DB Backup Job
0600AM - 0800PM : Transaction Log Backups Every Hour.
Please let me know, if there is any order we need to follow. Timing is never been an issue anyway, becuase it will be based on Business Reqs.
.
March 31, 2003 at 11:20 am
I've always preferred to run my backups before I do index rebuild and integrity check, my theory being that if something goes wrong during either of those two I'd like to have a good backup. In practice it's never mattered.
Andy
March 31, 2003 at 1:56 pm
Thank You Andy.
.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply