Sample Header Ad - 728x90

Why do indexes, statistics, and full text need to be rebuilt/updated/repopulated after migration?

-3 votes
1 answer
1030 views
I have created a new server, restored the system dbs and presented a copy of the data/log disks from the previous machine (or alternatively maybe I restore the user dbs using the .bak files). Post SQL Server migration, why do the following need to be performed: 1. Index rebuild on all databases 2. Statistics update on all databases 3. Repopulation of all full text indexes (or rebuild all full text catalogs) Example: https://www.sqlservercentral.com/articles/sql-server-migration-1 Does the answer differ whether the upgrade was done in-place vs by restoring from bak files? And server version vs different version?
Asked by variable (3590 rep)
Aug 19, 2022, 08:07 AM
Last activity: Aug 29, 2022, 05:17 AM