September 5, 2013 at 6:10 pm
Dear SQL experts,
I am planning to setup some Maintenance Plan including System database backup, users databases backups and Maintenance clean up tasks.
my question is:
1. Should I creating one Maintenance Plan or separate such as 1 plan for system dbs and another users db?
2. Should I also create check integrity
3. How should I create Maintenance clean up tasks for all DBs?
would someone plz help me with easy steps to setup sysDBs and UsersDB?
Thank you
September 5, 2013 at 7:54 pm
It's really "preference". Personally I like to segregate out my system stuff from the user stuff for my own peace of mind
I would recommend creating separate full backup & differential backup plans both system and user databases. If you are concerned about point-in-time recovery, I would recommend having your user databases in FULL recovery and also create a transaction log backup job to cover those databases. DEFINITELY have a CHECKDB job (what good are the fancy maintenance plans for backups if you've got corrupted data and can't actually restore them anywhere - set this job up for ALL DATABASES and schedule it to run no less than once/week)
Depends on which clean-up tasks you are referring to...if 3rd party software or custom scripts (Google Ola Hallengren) are not an option for you, I would recommend you at least set up 1) Reorganize indexes 2) Rebuild Indexes 3) Clean up history 4) Update Statistics and 5) Maintenance cleanup for however long back you want to keep backups for (I use 10 days due to limited storage, but would prefer 2 weeks)
Let me know if you have any further questions
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 5, 2013 at 8:09 pm
Thank you so much sir for you valuable input.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply