I would do a fresh install.
Moreover, after attaching or restoring the databases I would run the
following on all of them to enable new SQL2005 features:
Allways:
ALTER DATABASE [dbname] SET PAGE_VERIFY CHECKSUM;
DBCC CHECKDB ('dbname') WITH DATA_PURITY;
DBCC UPDATEUSAGE ('dbname');
Doublecheck with your Application Vendor:
EXECUTE sp_dbcmptlevel [dbname], 90;
Regards
Daniel
"Vanessa van Gelder "
<mssqldba-ezmlmshield-x75623659.[Email address protected]
31.07.2007 13:19
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
Fresh Install or Upgrade
If you were upgrading from SQL Server 2000 to 2005 would you do a fresh
install or would you just upgrade, I ask this because sometimes I think a
clean install just works that much better.. and has less residue issues..
Any input?
Vanessa Fredanus- van Gelder| SQL DBA | DXS Systems | Tel. +27 21 853
3317|
Fax. +27 21 854 7953
When I was young, I used to admire intelligent people; as I grow older, I
admire kind people. Abraham Joshua Heschel
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**********************************************************************
This e-mail may contain confidential material. It is intended only for the person or entity which it is addressed to. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you received this e-mail in error, please immediately notify the sender or The Swiss Raiffeisen Group and delete the material from any and all computers it may be stored on. Any views or opinions expressed in this e-mail are those of the sender and do not necessarily coincide with those of The Swiss Raiffeisen Group. Therefore this e-mail does not represent a binding agreement nor an offer to deal. E-mail transmission cannot be guaranteed to be secure or error-free. Information could be intercepted, corrupted, lost, destroyed, incomplete or may contain viruses. Neither The Swiss Raiffeisen Group nor the sender can accept any liability for any kind of damage as the result of viruses or transmission errors.
**********************************************************************
MS Sql Server LazyDBA home page