upgrade to SQL 2008 from SQL 2000

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  December 15, 2010 at 8:03 am

  #230735

  hi friends,

  I had done upgrade to SQL server 2008 from SQL server 2000, in which is IN PLACE upgrade method on same existing server also updated with SP2.

  Database size is 5GB and simple recovery model and database which is connected to VB application, it was working fine with no issues

  What is the configuration and memory setting should be following after up –gradation in SQL 2008 box?

  I have done this command as follows

  1.Alter database set compatibility level = ‘100’

  2.DBCC updateusages (DBname)

  3.DBCC checkdb (DBname) – there is no error

  Please tell me anything else need to be execute.

  Thanks

  ananda

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  December 15, 2010 at 11:45 am

  #1263055

  I think you have done all the necessary things. Also try to run the update statistics.

  Also you need to check for any code that is using the discontinued features like Joins using *= and =* , Order by clause with Column alias etc..,. This has to be done before doing the upgrade, most probably using Upgrade advisor.

  Thank You,

  Best Regards,

  SQLBuddy.

• JeremyE

  SSCoach

  Points: 16201

  More actions

  December 15, 2010 at 5:30 pm

  #1263240

  Looks like you hit most of them. Here is my post upgrade list.

  1. Change db compatibility to 100

  2. Change page verify from torn page detection to checksum

  3. Run DBCC UPDATEUSAGE

  4. Update statistics

  5. Run DBCC CHECKDB WITH DATA_PURITY