locked
Upgrade/migratation from sql server 2000 to sql server 2008 RRS feed

  • Question

  • Hello Friends,

    I want to Upgrade/Migration from SQL server 2000 to sql server 2008.i have 3 sql server and havce 300 gb database size.

    please share us complete road map ,how to proceed .i want to do this activity as soon as possible.


     


    Thanks & Regards, Vijay Jain Executive - Infrastructure Services | Maestros Mediline Systems Ltd. Phone: +91 – 22 - 2761 1311 /+91 – 22 - 4119 3100 |Mobile: +91 – 9870291860| www.maestros.net
    Saturday, July 30, 2011 6:57 AM

Answers

  • Hi,

    There are multiple thing you need to consider before starting upgrade.

    1.install and generate report of upgrade adviser

    download or copy it  form setup media of sql server 2008

    2.based on the report we will proceed for other

    3.report will give you road blocks to upgrade ex.encrypted stored procs,DTS packages,Maintenance plans

    4.If you are fine to proceed with report then move forward

    5.Apply sql server 2000 latest service pack (sp4, 2039 is build)

    6.Check your sql 2000 edition and sql 2008 setup media edition ,they should be same

    7.before starting upgrade take all user and system databases full backup in safe loaction

    8.install .net  framework,windows installer form 2008 setup media

    9.start sql 2008 installation,and select appriate  instance to upgrade ,we have to one after one

    10.hope everything goes well sql version will get upgrade to 10.xx.xx

    11.after upgrade change all databases compatibility level to 10 from 8

    12.execute sp_updatestats on all user databases

    13.Have a look in legacy folder

    14.upgrade DTS,Maintenance plans,SQL mail(if u have)

    most imp design back out plan also

    1.uninstall sql 2008

    2.uninstall all sql components form add /remove programs

    3.reboot os

    4.install sql 2000,apply service pack4

    5.restore all system and user databases

    Hope you the idea to proceed .All the best



    Sivaprasad.L Together We can Achieve
    • Proposed as answer by Madhu K Nair Monday, August 1, 2011 2:27 AM
    • Marked as answer by Peja Tao Tuesday, August 2, 2011 5:35 AM
    Saturday, July 30, 2011 7:23 AM

All replies

  • Hi,

    There are multiple thing you need to consider before starting upgrade.

    1.install and generate report of upgrade adviser

    download or copy it  form setup media of sql server 2008

    2.based on the report we will proceed for other

    3.report will give you road blocks to upgrade ex.encrypted stored procs,DTS packages,Maintenance plans

    4.If you are fine to proceed with report then move forward

    5.Apply sql server 2000 latest service pack (sp4, 2039 is build)

    6.Check your sql 2000 edition and sql 2008 setup media edition ,they should be same

    7.before starting upgrade take all user and system databases full backup in safe loaction

    8.install .net  framework,windows installer form 2008 setup media

    9.start sql 2008 installation,and select appriate  instance to upgrade ,we have to one after one

    10.hope everything goes well sql version will get upgrade to 10.xx.xx

    11.after upgrade change all databases compatibility level to 10 from 8

    12.execute sp_updatestats on all user databases

    13.Have a look in legacy folder

    14.upgrade DTS,Maintenance plans,SQL mail(if u have)

    most imp design back out plan also

    1.uninstall sql 2008

    2.uninstall all sql components form add /remove programs

    3.reboot os

    4.install sql 2000,apply service pack4

    5.restore all system and user databases

    Hope you the idea to proceed .All the best



    Sivaprasad.L Together We can Achieve
    • Proposed as answer by Madhu K Nair Monday, August 1, 2011 2:27 AM
    • Marked as answer by Peja Tao Tuesday, August 2, 2011 5:35 AM
    Saturday, July 30, 2011 7:23 AM
  •  

    Hi, 

    You should also perform dbb updateusage. 

    Please also read SQL Server 2000 to 20008 upgrade Whitepaper from Microsoft if you have time :) 

    p.s 

    Because you have large database I suggest that you perform update statistics with full scan insted of sp_updatestats. 


    Slaven Sola MCITP DBA,MCT ------------------------------ Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Tuesday, August 9, 2011 9:38 PM