August 25, 2008 at 10:37 am
Sorry for double post (in administring section) I thought this would be a better forum though after i posted the first one...
I am working on a plan to migrate all the databases from SQL 2000 to 2005 using the copy db wizard.
After the migration as sugested I need to update ( or in my case since its better option rebuild ) all the indexes.
As I understand it rebuilding indexes will update stats automaticly equal to full scan and so I dont have to do that? correct?
What I am looking for is a way to rebuild all indexes on the server (all users databases, all indexes ) using a script.
I am not concerned with down time as much as doing it right and making sure the performance and everyhting else is good afterwards.
I am fairly new DBA, read many books on SQL but still didnt get into T-SQL (just starting)
I must have seen tons of different statements COMPLETLY yet all doing same thing?
Does anyone have a good script or command I can run to rebuild all the indexes after the migration before puting the server online? I would rather not do it database by database if posible as there is 20+ of them. I want to make sure the indexes and stats are good after migration and performance is not hit in anyways. AGAIN I WOULD RATHER HAVE DOWN TIME durring migration that latter when $hit hits the fan!
Thanks for your help!
P.S. If there is anything else I should do post-migration by all means share with me. Very open to suggestions.
August 25, 2008 at 12:49 pm
Please don't double most. Lots of people check all forums.
Answered here: http://www.sqlservercentral.com/Forums/Topic558262-146-1.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply