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 |
|
kishore chittam
Starting Member
10 Posts |
 Posted - 2007-11-16 : 01:27:02
|
| I need to create sql 2005 standard maintenance plan for system and user databases and database maintenance plan should include Reorganize index task, full backup task, maintenance cleanup task(for backup files), history cleanup task. What should be the tasks order ? please let me know....I have to complete this on 8 servers by 11/16/2007 10 AM PST In sql 2000 database maintenance plan, any rebuild index task is there ?? |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-16 : 09:47:56
|
| you want to perform all data maintenance prior to the backup, so if the backup needs used then no after restore mainenance is required, which would prolong the delay before the database is available.use the default order from the maintenance plan wizard"reorganize data and index pages" does perform dbcc dbreindex |
 |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2007-11-16 : 14:39:00
|
| [quote user="kishore chittam"]What should be the tasks order ? please let me know....I have to complete this on 8 servers by 11/16/2007 10 AM PST[/quote]Then you should have paid attention to this much earlier than now, shouldn't you? |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-11-16 : 16:20:05
|
quote:
Originally posted by kishore chittam...I have to complete this on 8 servers by 11/16/2007 10 AM PST...
You posted your question at 11/16/2007 10:27 AM PST, so I think you are going to be late.CODO ERGO SUM |
|
|
|
|
|
|
Database maintenence plan