June 8, 2010 at 6:24 am
Hi All,
Am tried to re-create the maintenance plans of SQL 2000 in SQL 2008.
while doing that i have question for myself.
1. In SQL 2000, we have an option of Remove backup files older than 2/n-days like that.
But i couldn't find the option while creating Maintenance Plans in SQL 2008.
Is there any other option or control we need to place it in the Maintenance plan to achieve this or else we have to daily delete or write a custom job to delete the files from the respective backup folder???
2. Again, in 2000 we have Update Data Optization information which will basically gives us an option to
a)Reorganize data and index pages
b)update statistics used by the query optimizer??
c)Remove unused space from the database files
3. Again, i cannot see a Integrity check wizard in sql 2008.
For 2 & 3, i could find it in sql 2008 maintenance plans. But i can find 3 different tasks like
-Re-organize Index Task
-Update Statistics Task
-Check Database Integrity Task.
Do i need to use these as different Sub-plans in single Maintenance Plan?? Are these are the
substitutes for them? Just want to confirm ?
Thanks in Advance
June 8, 2010 at 11:26 pm
What I do is - In the same subplan I had a "Maintenance cleanup task" to remove the files more than 8 days
hope that helps
June 9, 2010 at 12:01 am
Thank You!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply