I would like to find out what the steps are to migrate a 2000 database up to 2005?
Either BACKUP the SQL 2000, and RESTORE to the SQL 2005
OR
DETACH the database file and ATTACH it to SQL 2005
In both situation, you will then want to rebuild the indexes and update the statistics.
|||what steps do I take to rebuild the indexes and update stats?
Is the option to select within sql server to rebuild the indexes and update the stats?
|||Look in Books Online about how to use:
DBCC dbreindex DBCC updateusage UPDATE STATISTICS
No comments:
Post a Comment