June 21, 2016 at 9:01 am
We are planning to do the migrations
I am following the checklist
https://www.mssqltips.com/sqlservertip/1936/sql-server-database-migration-checklist/
1) When I restored to different server the owner of the db is showing my name. Is there any way to change this automatically without running manual script
2) I think it is mandatory to run the update statistics after upgrade. Is there any specific reason behind this or this is just to take the baseline
3) When we restore the db to different server, fragmentation will be the same. If yes and it is less fragmentation then we don't need index maintenance
4) With db restoration does statistics will change? Do we need update only Index statistics or all statitistics?
5) If we have 10 database. Does we need to recompile all storoed procedures in all databases after migration?
Thanks in advance
June 21, 2016 at 4:28 pm
1) When I restored to different server the owner of the db is showing my name. Is there any way to change this automatically without running manual script -- you can login as SA or
ALTER AUTHORIZATION ON DATABASE::['DatabaseNameHere'] to sa;
2) I think it is mandatory to run the update statistics after upgrade. Is there any specific reason behind this or this is just to take the baseline
http://www.sqlservercentral.com/Forums/Topic1013402-391-1.aspx
3) When we restore the db to different server, fragmentation will be the same. If yes and it is less fragmentation then we don't need index maintenance. Well, you always need to do index mainenance but you do not need to do it right after a restore if you just ran it.
4) With db restoration does statistics will change? Do we need update only Index statistics or all statitistics?
http://www.sqlservercentral.com/Forums/Topic1013402-391-1.aspx
5) If we have 10 database. Does we need to recompile all storoed procedures in all databases after migration? No.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply