This question came from our site for professional and enthusiast programmers.

1

Voting to move this to ServerFault.com - our site for Administrators.
–
Raj MoreMar 21 '11 at 12:31

1

You should accept answers to some of your past questions. Not only will this show your appreciation for the people who spent their own time to help you, but it will improve your accept rate and the chances that they will answer any future questions you may have.
–
marc_sMar 21 '11 at 12:34

I know these basic stepd but can you tell me what other scripts I am supposed to run after upgrade? like rebuild indexes on all tables or anything else?
–
user75231Mar 21 '11 at 13:10

User643062: Remember that logins are not imported, even thou users are (as you can't restore the old master db over the new master db, given the sql versions, iirc).
–
3moloMar 21 '11 at 13:10

user75231: no need to run anything, it will work as it is.
–
3moloMar 21 '11 at 13:10

One thing that I would normally do is to run sp_changedbowner to change dbo to an existing user.
–
Nils Magne LundeMar 21 '11 at 13:16

user 3molo thanks for your quick reply. I know about logins not getting imported. When I ran test of restore last week and some of crystal reports were running very slow on this restore somebody asked me did you rebuild all indexes? update statcis? So I was not sure What all I need to do after upgrade?
–
user75231Mar 21 '11 at 13:17