May 19, 2006 at 1:07 am
Hi people!
Which is the right order for the maintenance jobs? It want to schedule this jobs:
- reorganzize data and index pages
- check database integrity
This Jobs have a fixed schedule:
- full database backup (i make this after the dwh-loading)
- trn-log backup (currently every hour)
Thanks in advance and nice regards from Austria
Juergen
May 19, 2006 at 9:14 am
I don't think there is an absolute " right order" it depends upon your window and circumstances. I usually do the integrity checks first, checkdb, check catalog. Then I usually rebuild indexes, update stats, dbcc update usage . I prefer not to use sysmaint or plans, prefering to use native sql for jobs.
In an ideal world I guess you'd want to backup after everything was completed, but you might want to back up first just in case the checks screwed the database !!!
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply