SQL Server Performance

Upgrade from 2000 -2008 R2 - need some answers

Discussion in 'SQL Server 2008 General DBA Questions' started by sql_jr, Sep 20, 2010.

  1. sql_jr New Member

    Hi, all:
    I have a planned upgrade from 2000-2008 upcoming, and need tips on what I need to know for sp_configuration settings.
    For example, xp_cmdshell is turned off by default...What other configurations will I need to look for and/or configure? THX
    Any links are good too!
    sql_jr, Sep 20, 2010
    #2

  2. satya Moderator

    Recently in MS Tech-Ed North America and most of the European conferences I have talked about this subject extensively. You might search on www.msteched.com site to find that presentation and also on www.sqlbits.com website.
    The first place to start is to run Best practices analyzer to get list of practices on your environment, as a general practice it is recommended to DISABLE/STOP but it may be required by your application.
    satya, Sep 20, 2010
    #3

  3. sql_jr New Member

    Thx for quick reply! I'll search, but it would be great if you can post the direct link....
    What about the Upgrade Advisor? Much value?
    sql_jr, Sep 20, 2010
    #4

  4. satya Moderator

    satya, Sep 30, 2010
    #5

  5. charlii New Member

    I just did migration from 2000 -2008 R2 by following the steps given by you guys.Your tips really works.
    charlii, Oct 28, 2010
    #6

  6. Luis Martin Moderator

    [quote user="charlii"]
    I just did migration from 2000 -2008 R2 by following the steps given by you guys.Your tips really works.
    [/quote]
    Good for you!!
    Luis Martin, Oct 30, 2010
    #8

  7. snivas Member

    Hi
    I Did this Migration successfully..I did not came across the any problem
    Here my Steps
    1.Install .Net frame work and Windows Installer 4.5
    2.Install SQL Server 2008R2 and hotfix(SQLServer2008R2_RTM_CU3_2261464_10_50_1734_x64 )
    3.Take the full Backups of all Databases form SQL Server 2000 and restored in SQL Server 2008R2 with NO RECOVER(to reduce the Down time)
    Link http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2261464&kbln=en-us
    4.Transfor the Logins
    http://support.microsoft.com/kb/918992
    http://support.microsoft.com/kb/246133
    http://technet.microsoft.com/en-us/library/ms137870.aspx
    6.Take Transactional backups of all databases
    7.Stop the SQL Server 2000
    8.Create Newalias name for SQL Server 2008r2 which suppose same as SQL Server 2000 Name and assing the Port as 1433
    7.restore TRN with with Recovery.
    I followed above steps...and successfully completed..Migration.
    snivas, Oct 28, 2010
    #9

  8. dzrihen New Member

    ***REmoved as it is incomprehensible
    dzrihen, Mar 7, 2011
    #10

  9. satya Moderator

    Removed the text posted by 'dzrihen' poster as it refers to a third-party tool which is unrelated to the topic.
    satya, Mar 7, 2011
    #11

Share This Page