Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-06-08 : 08:24:44
|
| 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 files3. 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 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-06-08 : 08:55:35
|
| All the objects are there:1) Use the Maintenence Cleanup Task.2) Use the Optimise Task3) Use the Integrity Check Task.These are all objects in the Ledft hand pane where you got the Backup Task from. |
 |
|
|
jimmycjen
Starting Member
15 Posts |
Posted - 2010-06-08 : 14:59:10
|
| -- To remove files older than n daysuse "Maintenance Cleanup Task"-- For integrity checkuse "Check Database Integrity Task" |
|
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2010-06-09 : 02:00:26
|
| Thanks All! |
|
|
|
|
|
|
2008 Maintenance plans