SQL Server 2008 : Enfin un document complet sur les mises à jour de SQL Server
Je vous laisserai en juger par vous-même…
http://www.microsoft.com/downloads/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en
Mais rien que cette petite partie attendue par la communauté depuis la sortie de SQL Server 2005 :
General Post-Upgrade Tasks
Whether you are doing an in-place upgrade or a side-by-side upgrade, you must execute the following post-upgrade steps:
- Execute DBCC CHECKDB WITH DATA_PURITY to check the database for column values that are not valid or are out of range. After you have successfully run DBCC CHECKDB WITH DATA_PURITY against an upgraded database, you do not have to specify the DATA_PURITY option again because SQL Server will automatically maintain "data purity." This is the only DBCC CHECKDB check that you must run as a post-upgrade task.
- Execute DBCC UPDATEUSAGE on all attached databases to update usage counters and make sure that correct values exist for table and index row counts.
- Update statistics on all databases after you upgrade them. Execute UPDATE STATISTICS in user-defined tables in SQL Server databases.
- Repopulate full-text catalogs. For information about this task, see Chapter 6, "Full- Text Search."
- Make sure that the relational databases are working correctly by executing a sample set of queries.
- Update any scripts affected by SQL Server 2008 behavior changes.
Témoigne d'un très gros effort de la part de Microsoft que je peux que louer !
Vous retrouver un article à ce sujet ici même : http://blogs.codes-sources.com/christian/archive/2007/03/27/sql-server-migrer-de-2000-2005-les-commandes-indispensables.aspx
Ces conseils restent bien entendus valable pour une mise à niveau de SQL Server 2000 vers 2008.
Bonne lecture…
Ce post vous a plu ? Ajoutez le dans vos favoris pour ne pas perdre de temps à le retrouver le jour où vous en aurez besoin :